Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the following ERD for a University: 1) Derive the business rules (5pts) 2) Translate the notation to Crow's Foot notation) (5pts) CName COffice CPhone
Given the following ERD for a University:
1) Derive the business rules (5pts)
2) Translate the notation to Crow's Foot notation) (5pts)
CName COffice CPhone Rank ld 1Office IName IPhone INSTRUCTOR COLLEGE DEAN (1,1) (0,1) (0,N) CStartDate (0,1) (0,N) CHAIR (1,1) ADMINS (1,1), MName. (1,1) DName DCode DOffice DPhone (0,N) FName LName EMPLOYS Sld SName (0,N) DOB Addr DEPT HAS STUDENT Phone (0,N) (0,1) Major (0,N) Grade TEACHES OFFERS TAKES (5,N) (1,1) (1,1) Secld CCode COURSE SECS SECTION SecNo Credits (0,N) (1,1) Sem CoName CDesc DaysTime Year CRoom Level Bldg RoomNo
Step by Step Solution
★★★★★
3.51 Rating (168 Votes )
There are 3 Steps involved in it
Step: 1
1st answer Business Rules A college can have one dean 11 A dean belongs to one college 11 A college ...
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
Fundamentals Of Database Systems
Authors: Ramez Elmasri, Shamkant Navathe
7th Edition
0133970779, 978-0133970777
