Scribd
Upload
5 views2 pages

Databases Unit 2 Assignment

The document outlines the relationships and key attributes for four entities: Product, Customer, Order, and Inventory. It describes the one-to-many relationship between Products and Orders, as well as the one-to-one relationship between Products and Inventory. Additionally, it emphasizes the use of primary keys, such as ProductID, CustomerID, and OrderID, to uniquely identify each entity and their relationships.

Uploaded by

robert
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views2 pages

Databases Unit 2 Assignment

The document outlines the relationships and key attributes for four entities: Product, Customer, Order, and Inventory. It describes the one-to-many relationship between Products and Orders, as well as the one-to-one relationship between Products and Inventory. Additionally, it emphasizes the use of primary keys, such as ProductID, CustomerID, and OrderID, to uniquely identify each entity and their relationships.

Uploaded by

robert
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

UNIVERSITY OF PEOPLE

UNIT 2 DATABASES ASSIGNMENT

[Link] the four entities namely Product, Customer, Order,


and Inventory. Define the relationships between these entities and
identify key attributes for each entity.

Products

Relationships

-A product may have more than one relationship (one-to-many relationship


with

Order entity) with the order entity.

-Every order is a product that the customer is able to purchase.

-The product then uses a primary key to identify it.

-It then comprises fields for the product name, price, description and details
of the product.

Customers

Relationships

-One customer has more than one relationship with the order entity, allowing
them to place several orders.

-The customer is able to place multiple product orders.

-Each customer is a unique individual, their identity is determined by the


primary key CustomerlD.

-Additionally, the phone number and email address are designated to offer
Information formation about orders and the most recent details on messages
and emails.
-The customer’s residential address is provided for order shipment.

Order

Relationships

-One customer is associated with an order.

-The primary key OrderID is defined in order to uniquely identify the


customer’s.

-The foreign keys customerID is used to link the order to the customer.

Inventory

Relationships

-A specific product is linked to inventory.(one-to-one relationship with product


entity).

[Link] the above four identified entities and attributes into


tables with appropriate primary and foreign keys.

You might also like