Campbellsville University SQL Server Data Project

User Generated

Anabj

Computer Science

Description

In this assignment, you will start planning your database. You have five tasks:

1. Review this source for what an ERD (Entity Relationship Diagram) is: What is an Entity Relationship Diagram (ERD)?

2. Review this source for  SQL Server DataTypes with Examples

3. Select a database you will be building for this class, such as a student database, video store database or shop database. Determine requirements. Requirement Gathering And Creating Initial ER Model

4. Create an ERD for the selected database. This database should not be more than 5-7 tables.

5. Upload your ERD and a 2-page document explaining your ERD in detail. 

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please view explanation and answer below.

ONLINE DELIVERY ERD

An entry Relationship Diagram can be defined as a diagrammatic representation of
entities in a database. In this assignment I prepared an Entry Relationship Diagram of an Online
delivery. the entities in the diagram as seen are Customer, we have orders, payments and at the
end we have the product to be delivered.
Customers - The customer is the individual who want to buy a product. The attributes in
the entity should define the work they do and how they should do it. As seen the entities are
Customer Id, First name, address And Zip Code. The primary key and foreign key in our case is
the customer. the data type of the customer ID and Zip I'd is int as in to mean an integer. The
first and last name are the character which are the unicord with variables width and datatype is
nvarchar. The data type in the address is varchar since it is a character string with the variable
width.
Order- the order has the following entities customer ID, order I'd product I'd and order
time. The order Id is Laos a primary and foreign key. All the other entities in this case are
foreign keys. The data type of customer Id, order Id, and product Id is int where these are
integers. The data type of order time is datetime where it is in the form of date and time.
3.

Payment: The attributes of the entity ‘payment’ are Payment Id, Order Id,

Payment date, Payment type, Payment status, and Amount. The payment Id is the primary key.
The order Id is the foreign key. The data type of payment Id, and order Id is int where they ...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags