联系方式

  • QQ:99515681
  • 邮箱:99515681@qq.com
  • 工作时间:8:00-23:00
  • 微信:codinghelp2

您当前位置:首页 >> Database作业Database作业

日期:2020-08-17 11:18

Oracle 12c

Conceptual modeling requirements:


For all the entities you wish to store data about you must create ERDs to show the binary relationships between related entities, and then combine these ERDs to give the global view of the database system. All ERDs must be drawn by a modeling tool such as Visio and upload to the dropbox, a pdf is also permitted.


Database and tables requirements:


1.Create the e-commerce database on oracle1.


Each table must include a primary key and all necessary fields.  You must set the field properties as necessary to collect the current data. You must do a table design for each table showing a descriptive column name, data type, size, and constraints where necessary.


2.Use the prefix comm_ for each of your table names.


3.All products must belong to a category and products can have attributes such as colour or size.


4.Products must include prices.


5.The shopping cart must indicate products, prices and quantities and a status, i.e., checked out or not.


6.Customers must have relevant contact information.


7.Shipping may be to the home address or any other address. There must be a shipping status with a discreet set of values.


8.Populate each table with at least 5 records.

9.   save as database script file .sql


版权所有:编程辅导网 2018 All Rights Reserved 联系方式:QQ:99515681 电子信箱:99515681@qq.com
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。