Present a detailed data model for your project scenario. You can create your data model using Microsoft Visio 2010, which you will have access to through iLab and Microsoft Excel, which comes with Microsoft Office. Other tools may be used as long as the output is legible and conforms to standard format. (i.e., I will not be able to grade the data model if I cannot tell what it is supposed to be!). Your data model should include a minimum of an ERD and metadata chart (data dictionary).Deliverables for This Task
- Task 0 proposal (with any revisions or updates)
- A completed Data Model to include the following.
- An ERD, showing all tables, related attributes, and the primary and foreign keys. This diagram must show both the relationship and cardinality of the relationship using accepted notation. The ERD should be formatted to allow printing on a single 8x10 page. It should be submitted as a Word file (copy and paste from Visio).
- 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. Follow the format of the Data Dictionary supplied for Lab 3.
Place all documents for this deliverable in a separate zip file and submit it to the Week 3: Course Project Dropbox.
See the Syllabus section "Due Dates for Assignments & Exams" for due date information.
*Please create the ERD in Microsoft Visio*
Running head: CIS-336 COURSE PROJECT WEEK 1
1 CIS-336 Course Project Week 1 CIS-336 COURSE PROJECT WK 1 What is the name of your business?
The name of our business would be Burgermania.
Who will be the users of the system (managers, employees, customers)?
The users of the system will be employees and managers. The only way a customer would be
able to use a system is if they are using a self-ordering POS.
What product(s) and or service(s) does it sell? Be specific.
At my burger shop, we would sell burgers, French fries, chicken nuggets, and any other type of
dish that you would expect at an average burger place. However, we would have a food
challenge that would consist of eating 3 different burgers, 3 order of large fries, and 3 orders of
large chicken nuggets which you must complete within 30 minutes. This challenge, named ?The
3 Challenge? would not only increase our popularity to people wanting to try and conquer the
challenge, but it would set us apart from other similar fast food restaurants.
Who are the customers? What is the customer base?
The customer base would be anyone that has the same love for burgers that we do. It could be
customers of different ages, from 2 ? 95+.
What sales and distribution channels are used?
One distribution channel would be where we buy each of the components of the burger, such as
the bun, burger meat, tomato, lettuce, etc. The next distribution channel would be a separate
location where our factory would be. At this location, the lettuce would be prepared to be put on 2 CIS-336 COURSE PROJECT WK 1 3 burgers, the tomatoes would be sliced, the burger patties would be formed, and other components
of the burger would be prepared. The third distribution channel would be the restaurant itself.
How are payments made?
Payments will be made through our POS system. The only POS systems that will be able to
accept cash payments will be the ones where an employee is standing behind the register. Other
than that, the self-ordering POS systems will accept credit cards and debit cards.
Are products delivered or shipped to customers in some way?
No products are directly delivered to customers in a sense of transportation. The only materials
being transported are the components of our burgers. We as an establishment only serve the
customers their food.
Are sales reps involved? Are they paid on commission?
I don?t see the need for sales reps to be involved. We can send out mail flyers to our local
neighborhoods to get word of mouth. If all else fails, we could hire sales reps and they would be
paid based upon how many customers they do bring in. I believe that our product would sell
itself once our customer tastes how good our burgers are. What type of reports are needed by the business?
One report that the business would need would be a report that tracks revenue periodically.
Another report we would need would be a report that records the amount of customers that the
restaurant serves. In addition, we would need a report that would determine the quality of our
Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
About this QuestionSTATUS
Oct 14, 2020EXPERT
We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.
You can also use these solutions:
- As a reference for in-depth understanding of the subject.
- As a source of ideas / reasoning for your own research (if properly referenced)
- For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
STUCK WITH YOUR PAPER?
Order New Solution. Quick Turnaround
Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.
WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.