SIS Database Design Crossword: Keys, Queries, and Relationships

123456789101112
Across
  1. 1. This constraint ensures there are no duplicate student IDs.
  2. 4. This relationship type involves a student being associated with another student (e.g., mentorship or buddy system).
  3. 6. An operation used in query languages to fetch specific information from a table (e.g., SELECT).
  4. 8. The process of organizing a database to reduce data redundancy and improve integrity.
  5. 10. A formal query language for managing data in relational databases.
  6. 11. This key is used to uniquely identify a student in the SIS.
  7. 12. A set of attributes that together uniquely identify a student in the database.
Down
  1. 2. This type of relationship connects students to courses they are enrolled in.
  2. 3. The type of key that links student and course tables, ensuring no orphaned records.
  3. 5. This relational operation combines two tables based on a common attribute, like student IDs.
  4. 7. A visual representation showing the entities involved in the system (students, courses, professors).
  5. 9. A set of rules or principles followed to maintain the integrity and consistency of the data.