Hi guys I am working ony my databse project and basically I need just a little h

Question

Hi guys I am working ony my databse project and basically I need just a little help. I alredy finished my assignment, but there are two part that I dont know what to write.

Part 1 of the Assignment

Customer table with data [10%] - DONE

Product table with data [10%]- DONE

Part 2 of the Assignment

Figure of the database structure (tables, fields, relationships) [10%]- DONE

With your word processor, a brief description (a couple of paragraphs) in your own words of the entity defined by each table and the nature of the relationships [10%] - NEED HELP!!!

Two printed invoices [15% each for 30%] - DONE

Part 3 of the Assignment

Query [10%]-DONE

Report [10%]-DONE

With your word processor, write a reflection on the database of about a page, plus or minus. Describe ways in which a database can be implemented into your current or future work environment, not necessarily just in terms of invoices. (You will also participate in a discussion post discussing relational databases and various companies that use this technology.) [10%]- NEED HELP!!!

I'll attach picture of what I have done, so you can have an idea. My company is called nikemelandia sac which sells sport shoes for vip customer such soccer players, singers- you can make stuffs up too.

thank you

Explanation / Answer

Answer)

As I can see that the database consists of the data for the nikemelandia sac which sells sport shoes for vip customer such soccer players, singers. Thus in Part 1 of the assignment with the data and the table:

Customer table will consist of the customer details such as the buyer details of the soccer players, singers.

Product table will consist of the products in the inventory which are the products to be sold.

Part 2 of the Assignment consists of the structure of the tables and as we can see 2 more tables:

Order - Order table will consist of the orders of the OrderID with the customer for whom the order is.

OrderLine - OrderLine table consists of the data in the table for the customers, products and order of the products for the company.

Customer table has ID as primary key.

Order table has OrderID as primary key and fkCustID as the foreign key which references the Customer table.

OrderLine has the LineID as primary key and fkOrderID and fkProductID as foreign key which references the Order table and foreign key which references the Product table respectively.

Product table has got ProductID as the primary key.

The invoice page in the application shows the data related to the invoices and the data in the tables.

Part 3 of the Assignment involves the querying of the tables to get the desired output of the data in the application.

We can also prepare a Customer Report which contains the details of the customer and the products they have purchased and other details according to the requirement.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.