Question
In each semester at a university, a student may enroll in up to 6 classes, and an instructor may teach up to 4 classes. All
In each semester at a university, a student may enroll in up to 6 classes, and an instructor may teach up to 4 classes. All users (including students, parents, instrcutors, school administrators) can view and search information about classes such as the IDs, titles, hours, locations, class sizes, instructor names, thier offices, emails, and phone numbers. Instructors and school adminstrators can also view, search, and maintain (insert, update, delete) all the information listed above, as well as student information such as the IDs, names, addresses, and phone numbers.
PART 1: What are the entity types in this database? List all the attributes of each entity type Specify primary keysand foreign keys of each entity type.
Part 2:Describe all the relationships, including name, associating entities, and multiplicities. You should write in the form of, for instance, Entity A(1.. 10)--->has-->(5..*) Entity B, which means, for Entity A and B, there is a "has" relationship from A to B, and the multiplicity of A is 1.. 10, and the multiplicity of B is 5..*
State your assumptions if necesarry.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started