Create Assumptions based on purchase agreement and payment installments. Map you
ID: 3860342 • Letter: C
Question
Create Assumptions based on purchase agreement and payment installments.
Map your Entity Relationship diagram into relations and make sure that all the relations are in BCNF. Provide all the relations in the following format:
Studnet (StudentId, StudentName, Street, Suburb, State, PostCode, Email, ContactNumber)
Course (CourseId, CourseName)
Course_Student(CourseId, StudentId, grade)
foreign key (CourseId) references Course.CourseId
foreign key (StudentId) references Student.StudentId
Customer Purchase Agreement Project Name Start Date Tower Amount cac Payment Installments Tower Floor Amount Payment Record Date Time nt Nitt Bedroom Unit Single Triple Floor Count Unit AmountExplanation / Answer
Answer
In order to build a relation between tables from the given ER diagram satisfying BCNF rule following are the tables.
Tables
1) Project(ProjectID(PK),TowerNum(PK),Name(PK),Start Date,Tower Amount)
2) Customer(CustomerID(PK),Purchase Agreement)
3) CQC(ProjectID(FK),CustomerID(FK),Agreement Milestones(PK),Payment Installments)
4) Payment Record(ProjectID(FK),CustomerID(FK),Agreement Milestones(FK),Date,Time,Amount)
5) Tower(TowerNum(PK),FloorNum,Floor Amount)
6) Bedroom Unit(TowerNum(FK),Single,Double,Triple)
7) Floor Count(TowerNum(FK),Unit Type,Unit Amount)
Here,
PK --> Primary Key
FK --> Foreign Key
Foreign keys in CQC table references to primary keys in Project and Customer tables.
"ProjectID" attribute in "Project" table relates to "CQC" table and similarlly for "Payment Record" table and CustomerID attribute in Customer table relates to "CQC" table and similarlly, "TowerNum" attribute relates to "Project","Tower","Bedroom Unit" and "Floor Count" tables.