Question
Will upvote! MySQL, First make a data dictionary that outlines all of your data elements(include in the chart if it is primary key/foreign key, the
Will upvote! MySQL, First make a data dictionary that outlines all of your data elements(include in the chart if it is primary key/foreign key, the column name, data type, identity, nullable, and default. example of a data dictonary will be at the end of this question!)
Make sure to identify primary and foreign keys for the tables
Tables to be made and used with the data dictionary will include:
Your company sells 10 unique items, with wholesale (purchase) and retail (sell) pricing. The store keeps 100 of each item in stock at all times, and sells 25% of each 1-5 item weekly, and 20% of items 6 10 each week. Ordering to replenish stock is done weekly. This can be built using one or two tables
The company has 5 fulltime, and 5 part time employees, with 2 shift supervisors and one store owner. The owner needs to be able to contact them and know where to send their paychecks. This can be built using two or three tables, preferably three tables
The company also has equipment. The assets are tracked with the original purchase price of the equipment and item depreciation of 20% per year. This can be built using one or two tables
example data dictionary(has nothing to do with the question, just as a refrence for you to know what im looking for
Store sells the following items description T-Shirts Jeans Button Shirts Capris Jackets Coats Long Sleeve Shirts Socks Hats MFG Panther Okra Buckeye Tiger Duck Sparty Badger Wolverine Gator Item purchase price Sale price 50 23 24 15 19 29 10 6 52 35 39.50 75 25 13 16 4 6 Store equipment initial cost (S) description Refrigerator (2 each)500 cash register cash register shelving unit alarm system Age (months) 12 12 tem 200 150 1000 2500 12 12 Personnel Works for Part or Full ID ID Job 1 Owner 2 Shift 1 Supervisor 3 Shift 2 supervisor 4 Worker 1 5 Worker 2 Name Time Salar Bob Mike Mark Annetta Andrew $11 per hour $11 per hour $10 per hour $8 per hour $12 per hour $7.50 per hour 3 F | Accountant 7 Add 4 more part time people 1 P Store sells the following items description T-Shirts Jeans Button Shirts Capris Jackets Coats Long Sleeve Shirts Socks Hats MFG Panther Okra Buckeye Tiger Duck Sparty Badger Wolverine Gator Item purchase price Sale price 50 23 24 15 19 29 10 6 52 35 39.50 75 25 13 16 4 6 Store equipment initial cost (S) description Refrigerator (2 each)500 cash register cash register shelving unit alarm system Age (months) 12 12 tem 200 150 1000 2500 12 12 Personnel Works for Part or Full ID ID Job 1 Owner 2 Shift 1 Supervisor 3 Shift 2 supervisor 4 Worker 1 5 Worker 2 Name Time Salar Bob Mike Mark Annetta Andrew $11 per hour $11 per hour $10 per hour $8 per hour $12 per hour $7.50 per hour 3 F | Accountant 7 Add 4 more part time people 1 PStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started