Question

Need help answering these

We will do this one as a Word document or pencil and paper. The instructor will tell you how it is to be turned in when it is assigned. The instructor may also adjust the exercise's weight in points for Canvas.

I expect that it will be either a Word document or a well drafted, neat pen and paper drawing.

1) Design a database diagram for a product orders database with four tables. Indicate the relationships and identify the primary key and foreign keys in each table.  Explain your design decisions.

Customers CustomerlD CustomerName CustomerAddress CustomerPhone Orders OrderID Customers Order Date ShipAddress ShipDate OrderLineltems OrderlD Order Sequence ProductID Quantity UnitPrice Products ProductID Product Name QtyPerUnit UnitPrice In Stock OnOrder

2) Add the two tables below into the design for exercise one. Create additional tables and columns if necessary. Explain your design decisions.

3) Design a database diagram that allows individuals to be assigned membership in one or more groups. Each group can have any number of individuals and each individual may belong to any number of groups. (Hint: this is obviously a many to many relationship! Review DB Design 4 page in this module and/or page 313 of the textbook.) Create additional tables and columns as necessary. Not all tables will look the same; people will make primary key decisions on the bridge table that will change how it functions. The task is not completely specified; when (not if) you hit an ambiguity, make a decision and explain your design decisions!

4) Modify or extend the design for exercise three to track the role served by each individual in that group (i.e. "president", "secretary", "parliamentarian", etc.) Each individual can only serve one role in each group. Each group has a unique set of roles that members can fulfill (sounds like a foreign key jumping off here!) Create additional tables and columns as necessary. Not all tables will look the same; people will make primary key decisions on the bridge table that will change how it functions. The task is not completely specified; when (not if) you hit an ambiguity, make a decision and explain your design decisions!

Answer 1

Answer- Customer Contains order line item Product ER diagram and foreign Keys of The primary tables are: Table Primary key foreign key Customer Customer ID Order Customer ID order ID Orderline Items and Order ID + Order Sequence Order ID Product ID Products 1 Product ID

Explanation:

Customer places order <Contecins prodat product huset has a foredraget orderline Item supplied sur les have a batere

Design 1.-A Customer has a one-to-many relationship with the Order because a customer can place many orders, but a given order can be placed by only one customer.

The order has one to many relationship with OrderLineItem because. An Order can contain multiple OrderLineItems.

But An OrderLineItem has a one-to-one relationship with a product because an order line itemorderLineItem can refer to only one product.

In the above Diagram I submitted, Many to one relationship with the shipper, because shipper can have multiple products.

so there is one to many relationship between shipper and product.

the shipper can have many employees, and the relationship between shipper and employee should be one to many.

In the above scenario, there can be employee and order relationship is also possible. As one to many relationship.

we can also create an Invoice table to show the relationship between shipper invoice and employee.