Database Exercise 2 Answer questions 1 and 2 and then use your answers to help y

Question

Database Exercise 2 Answer questions 1 and 2 and then use your answers to help you design the ER diagram in question 3 for the database described in the tables after the questions. You will not be submitting your answers to parts 1 and 2 as they are automatically included in the ER diagram you create in question 3. Be sure to watch the tutorial videos before attempting this exercise. o Lucid Charts ERD Part 1: https://youtu.be/OpdhBUYk7Kk (6:57 mins) o Lucid Charts ERD Part 2: https://youtu.be/-CuYSADwn24 (13:51 mins) o Study Tonight - Basic Concepts of Database Normalization: https://voutu.be/xoTyrdT9S (8:10 mins) o LucidChart Basics Tutorials by LucidCharts: https://www.lucidchart.com/pages/resource-center?topic-Videos LucidChart Written Instructions: If you prefer web page instructions over videos, please visit: Identify the primary key for each table. (Some tables will have composite primary keys.) Customer: a. Account: b. CustomerAddress c. ZipCode: d. SalesRep: 1. 2. Identify the foreign key(s) in the: a. Customer: b. Account: c. CustomerAddress: Create an ER Diagram. Be sure to watch the videos a. b. 3. Create a free education account in Lucid Charts. Use Lucid Charts to create your ER diagram for the database described above. (Your entities will look similar to the figure below.) a. Be sure to indicate primary keys and foreign keys. b. Be sure to indicate cardinalities. c. Indicate the data type and field size that you think each field should contain . Varchar- This type is used for storing data that contains various characters that are not used in a calculation. A couple of examples would include a name which contains letters, but also an ID number such as AccountNo. since you would not use an account number to perform a calculation i. Number This type is used for numbers on which you might perform a calculation. ili. Date- This type is used for dates such as 12/1/2018 v. Currency-This type is used for costs or prices. Customer c. Download your ER diagram as a PDF d. Upload your ER diagram PDF to the dropbox. PK Customer ID int FirstName varchar(50) Street City Zip Phone varchar(50) varchar(50) varchar(5) varchar(10)

Explanation / Answer

1. Primary key for each table

primary key is a column or combination of columns using which you can identigy any record in database table uniquely. So we need to find the unique colum or columns.

There will be some keys like salesrepid in account table which is used for assocating the accounts with salesreps. those will not be considered as primary key.

Account : AccountNo

customer address : CustId and Addresstype

zipcode: zipcode

salesrep: salesrepId

Bookorders: OrderId

*As of chegg ploicy we can answer only first question post other questions as seperate.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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