ER DIAGRAM 2 ANSWER 3: RELATIONAL SCHEMA Director (dID, fullName) Actor (aID, fullName)
Added on -2019-09-16
3.2.4: the final schema is: Store (StoreID, storeAddress) Staff (staffID, staffMobileNumber, staffName, storeID*, salarygroup*) Work (staffID*, dateOfShift, hoursWorked, amount) Salarygroup_info (salarygroup, baseRate) ANSWER 4 We use binary relationships when two entities participate in a relationship.
| 5 pages
| 375 words
| 393 views
Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 2 of 5 pages
STUDENT NAME:10 November, 2016DB_ASSIGNMENT SOLUTION
ContentsANSWER 1: ER DIAGRAM................................................................................................................2ANSWER 2: RELATIONAL SCHEMA...............................................................................................2ANSWER 3.2........................................................................................................................................3ANSWER 4...........................................................................................................................................4
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan