Question: Number 1 : In this assignment, you have to convert the EER diagram above to create and query the database Convert the above EER conceptual

Number 1: In this assignment, you have to convert the EER diagram above to create and query the database
Convert the above EER conceptual schema into tables (relational model).
Do not forget to show primary keys and foreign keys on your tables.
Ex: Car Rental
P.K F.K
...........,,>
Number 2: Implement your tables constructed in part 2 in a DBMS of your choice ( ex:SQL Server, MySQL, ORACLE). You can use your choice of DBMS. If you havent used any of these before install WAMP server ( XAMP for linux) and use MySQL in WAMP server as I explained in the lecture.
In creation of your tables, make sure to place referential integrity constraints correctly in creation of your tables. Also populate your tables according to the queries in part 3 so that you have a logical answer for each query asked in part 3.
Need help on the 2nd Question
Number 1 : In this assignment, you have to

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 Programming Questions!