Draw an er diagram accordingly

Assignment Help Computer Engineering

Reference no: EM133550470

Question: Draw an ER diagram accordingly to the following user requirements.

A university has a set of classrooms scheduled for ..... exams. A classroom has a room number, building, and capacity. A classroom can be uniquely identified by a building and a room number. Each course has a course serial number, and a course name, and it belongs to a department. Each course can have one or more sections. Each section has a section number that is unique regarding the same course. Students are enrolled in a section. Exams are conducted in each section of a particular course. Each exam has an exam number that is unique regarding the same section of a course. The exam's result is also recorded i.e., the grades of students. Student's information includes SSN, name, and address. A name consists of a first name and a last name.

An address consists of street, city, state, and zip. You should identify the key or a partial key for each entity.

Constraints:

1. A course must have at least one section. A student should enroll in at least one section.
2. A section should be associated with one and only one course.
3. A section can have many exams and an exam belongs to just one section.
4. An exam can be conducted in many classrooms (e.g. at different time).
5. A classroom can have many exams conducted in it (e.g. at different time). We do not keep track of the time to conduct the exam.
6. A section should have at least one student.
7. An exam must conduct in a classroom.
8. Some classrooms may not host any exam.

The owner of a weak entity can be another weak entity.

Reference no: EM133550470

Questions Cloud

Discuss the honey guide bird safely enters to enjoy : Once the honey badger has ransacked the hive, the honey guide bird safely enters to enjoy the leftover honey.

What is the primary source off error in observational data : What is the primary source off error in observational data? Group of answer choices Observer Error Observer Drift Observer Training Observer Analysis

Describe why you choose communication methods face to face : Describe why you choose communication methods Face to face and emails most frequently and why you choose to communicate this way?

Solve the problem by upgrading the ram to 8gb : Solve the problem by upgrading the RAM to 8GB. Use this scenario and the Unit 2 IP template to complete this assignment

Draw an er diagram accordingly : Draw an ER diagram accordingly to the following user requirements and An address consists of street, city, state, and zip. You should identify the key

Discuss how that factor can affect our sense of self : discuss how that factor can affect our sense of self. One paragraph should reflect what you learned from viewing the two chosen videos, and the second paragraph

Output should round to the nearest dollar : The function should return the mean base salary for all employees of that job category with at least the given number of service years

Locate and fix errors in the code that set up the grid : The style rules for the horizontal navigation list and the section element also define grid styles for those elements. Locate and fix errors in the code that

Which would the engineer use : backup system creates aggregated jobs throughout the week based on this scheme. If the system required a restore during the week, which would the engineer use

User Account

All Pages