首页 > > 详细

代写data课程作业、代做SQL编程设计作业、代写program留学生作业、SQL语言作业代做代做R语言编程|帮做Java程序

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

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

联系我们 - QQ: 99515681 微信:codinghelp2
© 2014 www.7daixie.com
程序代写网!