Free MLA$*$Citation$...$

Home$-$Mylvy M Gmail

YouTube

Maps

your need to maintain the id$,$ name, address, city, state, zip, phone number, and point of contact name of each client.

KEY: Each customer must reference a sales agent id$.$

ENTITY: The order must contain the order number, quantity, date of order, and total cost.

KEY: Also, each order must reference the correct customer id and product id$.$

ENTITY: You also need to capture the sales agent information. This should include the agent id$,$ name, address, city, state, zip, and phone number.

Now that you have identified your data elements, construct a conceptual view of your table using Excel. A conceptual view represents how the data will be displayed to the end user, in a relational database it will be returned in a tabular format, use Microsoft Excel to create a view of your new schema. Click the link to view a video on how to create a table in Excel. $3$

Once the entities are created, you'll need to identify any primary and foreign key columns$/$attributes based on the business rules supplied. In the heading of the column that will serve as the Primary Key $($PK$)$ of each table include $($PK$)$ and use $($FK$)$ for any column that acts as the foreign key $($FK$)$ in the table.

Remember that a PK is a column constraint that uniquely identifies each row, it cannot be repeated. An FK is a column constraint that enforces referential integrity and establishes the relationship. It is a pointer to a related row$($s$)$ in another entity.

Include at least two rows in each table to represent the type of data that can be stored in each table. An example of the final outcome is provided below.

Conceptual View Example darr

Notes & Tips:

Additional online research can be done on the topic.

This exercise will be the building block for your group project.