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 : 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
PK FK
Number : Implement your tables constructed in part 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 so that you have a logical answer for each query asked in part
Need help on the nd Question
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
