Assignment One (1) With the aid of the figure below, answer the questions that follows The figure above is a database that stores student and course information. Specify all the relationships among...

Assignment One (1)

With the aid of the figure below, answer the questions that follows

The figure above is a database that stores student and course information.

• Specify all the relationships among the records of the database


• Give some additional views that may be needed by other user groups for the database.


• Cite some examples of integrity constraints that you think can apply to the database.


• Think of different users for the database. What types of applications would each user need? To which user category would each belong, and what type of interface would each need?


• Give examples of systems in which it may make sense to use traditional file processing instead of a database approach.

Extracted text: GRADE REPORT Student_number Section_identifier Grade 17 112 B 17 119 8. 85 A 8. 92 A 8 102 B 8. 135 A PREREQUISITE Course_number Prerequisite_number CS3380 CS3320 CS3380 МАТН2410 CS3320 CS1310


Extracted text: STUDENT Name Student_number Class Major Smith 17 1 CS Brown 8 2 CS COURSE Course name Course_number Credit_hours Department CS1310 Intro to Computer Science Data Structures Discrete Mathematics 4 CS CS3320 4 CS MATH2410 3 МАТH Database CS3380 3 CS SECTION Section_identifier Course_number Semester Year Instructor MATH2410 Fall King Anderson 85 07 92 CS1310 Fall 07 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang 119 CS1310 Fall 08 Anderson 135 CS3380 Fall 08 Stone