Question: (b) Briefly explain about basic attributes and additional attributes in ERD. By referring Figure Q2, analyse and complete the ERD with the basic and additional

 (b) Briefly explain about basic attributes and additional attributes in ERD.

(b) Briefly explain about basic attributes and additional attributes in ERD. By referring Figure Q2, analyse and complete the ERD with the basic and additional attributes (including primary and secondary keys) so that it can be applied in database management system such as Microsoft Access. You may add new entities (if required) to support your answer. (15marks) (30 marks) SKAB 34123 834123 for Registration Information Date of Registration Expiry date of Registartion Company Rubber Stamp howe Address Contractor for No./ Lot Road City Postcode State Country Contractor Name Contractor Status Tel. No. 1 Tel. No. 2 Fax No. E-mail Web Site have have Staf mariage Manage by Name Position Address Home Tel. No. Hp No. Email Works Project Project Name Location Start Date End Date Project Owner Project Cost FIGURE 02

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!