I AM SO LOST PLEASE HELP . I need to make a Data Dictionary (or meta data chart)
ID: 3883423 • Letter: I
Question
I AM SO LOST PLEASE HELP.
I need to make a Data Dictionary (or meta data chart) showing a minimum of the table name, columns, data types, length, and constraints. It should be submitted as an Excel file.
The following is what I have to make the data dictionary from:
Big Blue Beef Jerky
My business will be opening a beef jerky shop in Lexington, Kentucky. The name of the beef jerky shop would be 'Big Blue Beef Jerky'. The reason for opening this beef jerky shop in Lexington is due to it being a college town and the strong networking with the local community.
The competitive advantage that this company would bring is being precise about the health choices and taste desires of their customers. The purity and standard of their products will be the top priority. Furthermore, this business firm would assure the customers the maintaining promise of the purity and quality of each and every grain of all varieties of their products by offering a money back guarantee. If the customers are not satisfied with any of the purchased jerky from the shop they can simply bring it back with a receipt to gain full reimbursement. The aim of our firm would be to offer vivid varieties of mouth-watering beef jerky and our very special 'Big Blue Beef Jerky', a special beef jerky for the University of Kentucky sports fan.
The users of this business will basically involve the proprietor of the business, the manager to manage the sales counter, a supervisor and his assistant to take care of the making of various range of beef jerky and other jerky products, the customers who use our services over the counter. Finally, a team of marketing professionals to manage the online sales and marketing activities of the business.
The business will provide a fusion as well as authentic line of traditional beef jerky, high in quality for our customers. It will also adapt a line of specialty snacks that go well with the beef jerky when combined.
The targeted customer base initially would be the local students and residents as well as the tourists who come to visit the city and campus. Apart from this, we will launch a website that can cater to the orders of the customers located in the state of Kentucky outside of Lexington. Eventually, we will be open to take orders from across the country depending upon the online responses for our products.
The sales and distribution channel will be very basic and direct from our kitchen to the packaging team and from the packaging team to the transporting team, in case of online orders. There will be a few delivery drivers in the picture to handle the pickup and delivery points. In case there are out of the city orders, it will be sent through the courier system in place. This is how the products will be delivered and shipped to our customers.
The payments could be accepted both in the form of physical cash as well as through electronic transfers. However, in case of the online orders the payment should be purely in the form of electronic transfers for the jerky being ordered out of the base city.
Sales reps shall only be involved at the counter and in front of the company to promote our range of products to the physical customers. However, they will receive a fixed-base salary instead of performance-based commission.
The market review reports, online business of our firms' reports, latest consumption pattern reports, and the new availability of raw materials for producing a wide range of distinctive edible products. This will all be beneficial in the long run of my business.
Explanation / Answer
Hi, now you should have a fair idea as o how to proceed, you can take forward to modify the tables accordingly.
Please do not forget to give a positive like to the answer. Thank you.
table Shop Information Label data type Length Constraints S_id number 10 Primary key S_name String 20 not null Location string 20 not null Networks string 100 not null table Customer C_id number 10 Primary key C_name string 20 not null health_choice string 50 not null taste_desire string 50 not null Table Money back Label data type Length Constraints Mb_id number 10 Primary key C_id number 10 Foreign key Money_back_reason string 50 not null Money_back_amount inumber 10 not null Receipt_number number 10 unique key Table Menu Label data type Length Constraints M_id number 10 Primary key menu_name string 50 not null Table Staff Label data type Length Constraints Staff_id number 10 Primary key Staff_name string 10 not null Staff_designation string 10 not null Staff_area_of_expertiese string 50 not null Table Order Label data type Length Constraints Bill_id number 10 Primary key C_id number 10 Primary key order_id number 10 foreign key M_id number 10 foreign key Total number 10 not null Delivery_location string 50 check(location="Kentucky" and location != "Lexington") Table Delivery Label data type Length Constraints d_id number 10 Primary key courier_id number 10 foreign key order_id number 10 foreign key Payment_type string 10 primary key Table Courier Label data type Length Constraints courier_id number 10 Primary key name string 10 not null Table Payment Label data type Length Constraints Payment_type string 10 primary keyHi, now you should have a fair idea as o how to proceed, you can take forward to modify the tables accordingly.
Please do not forget to give a positive like to the answer. Thank you.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.