Chapter 4 – Lab Exercise
Using the EER diagram of the Horse Racing enterprise from Figure 3.23:
a) Write a relational schema for this EER diagram in a Word file or a text file. Underline primary keys and indicate foreign keys. Choose an appropriate representation for the Horse specialization, the Person specialization, the TrainerJockey multiple inheritance, and the Owner category.
b) Using Access, LibreOffice Base, or OpenOffice Base, create the database to correspond to the schema.
c) Insert several records in each table and print out the tables.
d) Using a Word file or a text file, write out five questions, design the queries, and execute them. Copy the results into your Word or text file, and print them out.
Chapter 4 – Lab Exercise
Examine the following ER diagram, which appears in the exercise section of Chapter 4:
Figure 4.9: (copy) E-R Diagram for CustomerOrder Example
a) Write a relational schema for this E-R diagram in a Word file or a text file. Underline primary keys and indicate foreign keys.
b) Using Access, LibreOffice Base, or OpenOffice Base, create the database to correspond to the schema.
c) Insert several records in each table and print out the tables.
d) Using a Word file or a text file, write out five questions, design the queries, and execute them. Copy the results into your Word or text file, and print them out.
以上发布均为题目,为保证客户隐私,源代码绝不外泄!!)
代写计算机编程类/金融/高数/论文/英文
本网站支持淘宝 支付宝 微信支付 paypal等等交易。如果不放心可以用淘宝或者Upwork交易!
E-mail:850190831@qq.com 微信:BadGeniuscs 工作时间:无休息工作日-早上8点到凌晨3点
如果您用的手机请先保存二维码到手机里面,识别图中二维码。如果用电脑,直接掏出手机果断扫描。