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

Students who viewed this