Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

12. (14 points) Consider the following set of requirements for a UNIVERSITY database that is used to keep track of the courses offered by departments.bni

image text in transcribed
12. (14 points) Consider the following set of requirements for a UNIVERSITY database that is used to keep track of the courses offered by departments.bni Yhgong ayol pool bn sinistro Each department is described by a name, department code, office number, office phone. Both name and code have unique values for each department. Each course has a course name, description, course number, number of semester hours, level, and offering department. The value of course number is unique for each course. Each section has semester, year, course, and section number. The section number distinguishes different sections of the same course that are taught during the same semester/year, its values are 1, 2, 3, ..., up to the number of sections taught during each semester. [8 points) Draw an ER diagram for this application. In the diagram, specify key attributes of each entity type and constraints on each relationship type. Note any unspecified requirements, and make appropriate assumptions to make the specification complete

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

What lessons in OD contracting does this case represent?

Answered: 1 week ago

Question

Does the code suggest how long data is kept and who has access?

Answered: 1 week ago