60.1K

Verified Solution

Link Copied!

Hello. I'm a little lost with this.

Supposed to be creating a database for a gourmet store.

This is what I have in my data dictionary so far:

this is an example of the data dictionary:

blank sheets of data dictonary and entity/attribute sheet

a. Determine the entities (tables) that will be needed. You can use the sheet similar to the sheet we used in class. A blank sheet is available on Moodle. You will need around 7 - 10 tables to properly complete this project. b. For each table, list all of the data elements that will be needed. Make sure all data elements are broken down to its smallest component, but not more, or less than 3rd normal form.. Having one or two attributes for a table will not work. You must have enough attributes to adequately describe the entity. c. The data dictionary that outlines All of your data elements. A blank excel spreadsheet is available on Moodle. d. Create an entity relationship diagram for your database. No hand drawn diagrams will be accepted. There are several software programs that can assist. You can use Microsoft Visio, Oracle Data Modeler, or Erwin Data Modeler. DO NOT use Microsoft SQL Server for project 1, as your project will not be accepted. e Identify primary/foreign keys for the tables. 3. Company Information: a. The company has the following characteristics: 1. The store has 10 unique customers. ii. The store has 2 locations. iii. The company has one owner, 2 branch managers, 4 cashiers, 2 Chefs, 4 Stock personnel, and 2 administrative assistants (one per location). The employees are distributed equally between the two locations. The owner sits at the main branch 1. NOTE. The Owner and branch managers have a yearly salary. $100K each paid on a monthly schedule, all have no overtime available 2. All others are paid hourly, $15 per hour, all are full time, with Overtime available. iv. They receive products from 6 different suppliers and sell to retail customers. 4. Automation: a. The company wants to automate the following functions: i. The incoming supplies ii. The bakery output ili. Retail sales iv. Employee information including payroll V. Customer information name Column Contents cumin Autom Columns Type Cwmns Fom Column Column SED PROFF Emoyens P FK 12345 00 apoi Ft Name La mg_Phone Pray for the employees Emberta Employmes Last and Employees Phone Number ind arch vartha ch BARAZA 0 10 11 013245-6356 13 14 10 19 Tabiiy 24 25 26 27 20 200 30 31 32 33 34 35 36 37 Ql Tadbyes 40 D F Contents E Format 3999 Range PK OFK Sue Type 6) Students 0.9 4 PK FX Table name Auto Name Students Counsel StudentFrame Studentame StudentAddress Studenty Student State Studentp Student Country StudentGPA Table ze in bytes The studenti Students instamo students name student street number and wat khi m ty students home state sidents home to code Students countrycode Students grade point average XXX XXX varchar) varchar) varchar(15) varchar(20) Charc) 015) Int2) demo43 BLAZ ZAZ ZAZ ZA AZ SZA 0-0 11 15 20 2 4 4 5 AN 0000 XX XX Teacher The student 0- 4 PK FK 1000 EX DO Bodenstam students atramo student of number and street shudents Students from state students home zip code Highest degree attained The e date of the employee XXX XX KO OOK Employee Course Employee Name Employee Employee Address . Employee State EmployeeZip Employee DegreLVL Employer Date Tables in bytes Cound CounName Courselype Courses LabFees Tables in bytes vachan) Vachar(1) varchar(15) varch 20 cha 2) int(5) Inc dato ZA 2 BLAZ BLAZ BAZ AZ ZA 00 0-9. 1930 11 15 20 2 4 4 XXX OK ON 761 Cones PK The course identification name of the course What type of contractionathyindonine Course description The lab fees involved ny) chario) varchar(10) varchar 2013 money KO XXXX O EX XXE XXX X ZA DZA Z 0-9 AZ 1-2 AZ 00 4 0 10 10 1 38 Database Calculation Number of students Number of the 05000 2500 10000 4745000 319500 684000 + Sheet1 Sheet2 Sheet3 Column Column Table name Column2 Attribute Name Column Contents Column Data Type Columns Format Columns Range Column PK OF Size e 1 PK FK Table in bytes 2 PK FK Tables in byles le 3 PK FK Table site in bytes tabase Calculation mber of students mber of teachers mber of course 65000 4500 18000 0 0 0 Designing a Database Attributes for entity Attributes for entity Attributes for entity Attributes for entity a. Determine the entities (tables) that will be needed. You can use the sheet similar to the sheet we used in class. A blank sheet is available on Moodle. You will need around 7 - 10 tables to properly complete this project. b. For each table, list all of the data elements that will be needed. Make sure all data elements are broken down to its smallest component, but not more, or less than 3rd normal form.. Having one or two attributes for a table will not work. You must have enough attributes to adequately describe the entity. c. The data dictionary that outlines All of your data elements. A blank excel spreadsheet is available on Moodle. d. Create an entity relationship diagram for your database. No hand drawn diagrams will be accepted. There are several software programs that can assist. You can use Microsoft Visio, Oracle Data Modeler, or Erwin Data Modeler. DO NOT use Microsoft SQL Server for project 1, as your project will not be accepted. e Identify primary/foreign keys for the tables. 3. Company Information: a. The company has the following characteristics: 1. The store has 10 unique customers. ii. The store has 2 locations. iii. The company has one owner, 2 branch managers, 4 cashiers, 2 Chefs, 4 Stock personnel, and 2 administrative assistants (one per location). The employees are distributed equally between the two locations. The owner sits at the main branch 1. NOTE. The Owner and branch managers have a yearly salary. $100K each paid on a monthly schedule, all have no overtime available 2. All others are paid hourly, $15 per hour, all are full time, with Overtime available. iv. They receive products from 6 different suppliers and sell to retail customers. 4. Automation: a. The company wants to automate the following functions: i. The incoming supplies ii. The bakery output ili. Retail sales iv. Employee information including payroll V. Customer information name Column Contents cumin Autom Columns Type Cwmns Fom Column Column SED PROFF Emoyens P FK 12345 00 apoi Ft Name La mg_Phone Pray for the employees Emberta Employmes Last and Employees Phone Number ind arch vartha ch BARAZA 0 10 11 013245-6356 13 14 10 19 Tabiiy 24 25 26 27 20 200 30 31 32 33 34 35 36 37 Ql Tadbyes 40 D F Contents E Format 3999 Range PK OFK Sue Type 6) Students 0.9 4 PK FX Table name Auto Name Students Counsel StudentFrame Studentame StudentAddress Studenty Student State Studentp Student Country StudentGPA Table ze in bytes The studenti Students instamo students name student street number and wat khi m ty students home state sidents home to code Students countrycode Students grade point average XXX XXX varchar) varchar) varchar(15) varchar(20) Charc) 015) Int2) demo43 BLAZ ZAZ ZAZ ZA AZ SZA 0-0 11 15 20 2 4 4 5 AN 0000 XX XX Teacher The student 0- 4 PK FK 1000 EX DO Bodenstam students atramo student of number and street shudents Students from state students home zip code Highest degree attained The e date of the employee XXX XX KO OOK Employee Course Employee Name Employee Employee Address . Employee State EmployeeZip Employee DegreLVL Employer Date Tables in bytes Cound CounName Courselype Courses LabFees Tables in bytes vachan) Vachar(1) varchar(15) varch 20 cha 2) int(5) Inc dato ZA 2 BLAZ BLAZ BAZ AZ ZA 00 0-9. 1930 11 15 20 2 4 4 XXX OK ON 761 Cones PK The course identification name of the course What type of contractionathyindonine Course description The lab fees involved ny) chario) varchar(10) varchar 2013 money KO XXXX O EX XXE XXX X ZA DZA Z 0-9 AZ 1-2 AZ 00 4 0 10 10 1 38 Database Calculation Number of students Number of the 05000 2500 10000 4745000 319500 684000 + Sheet1 Sheet2 Sheet3 Column Column Table name Column2 Attribute Name Column Contents Column Data Type Columns Format Columns Range Column PK OF Size e 1 PK FK Table in bytes 2 PK FK Tables in byles le 3 PK FK Table site in bytes tabase Calculation mber of students mber of teachers mber of course 65000 4500 18000 0 0 0 Designing a Database Attributes for entity Attributes for entity Attributes for entity Attributes for entity

Answer & Explanation Solved by verified expert

See Answer