Question
Please answer all questions completely. Following is an ER diagram for a university. 2.A.) (25 POINTS) Write the corresponding requirements specifications for this ER design.
Please answer all questions completely. Following is an ER diagram for a university. 2.A.) (25 POINTS) Write the corresponding requirements specifications for this ER design. Please make sure to consider each component. A good suggestion is to cross out each component as you process it so that nothing is left out. 2.B.) (15 POINTS) Specify the details for the following items: - Entities, weak entities, corresponding identifying relationship - Relationships, degree of each relationship - Attributes of each entity and relationship (if any) - primary key (PK) - Foreign key (FK)
ment course dept building budget inst dept stud dept instructor TD student ID advisor salary tot cred teaches takes grade section Course time slot saci seneste ACar time sl sec course title credits tday start hwie course id prereq id see class classroomm bunding University database ER diagram for question 2Step 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