Assignment:
Scenario:
Create a business proposal for a small retail store (you can make up this store).
The new retail store is going to choose among the business proposals (other companies will be giving proposals also) as to which database would be appropriate to use for their new business.
The retail store is in the initial phase of operations and would like to start with a small database that contains information about their customers, their products, suppliers and sales. In your proposal, you have included examples of the tables, queries, forms and reports.
1. Before you write this proposal, List at least 5 questions you would have asked in order to design the database.
2. Design the tables in your database and explain how they are related.Assign primary and foreign keys where necessary. Explain the purpose of each table.
• Design at least four tables for the business (ex: customer, supplier)
• Add at least 6 rows of information (ex: 6 customers to the customer table)
3. Design one query that the business owners may be interested in.
4. Design one form that you think would be valuable for the business owner to have.
5. Design one report that would be valuable for the business owner to have.
6. In the Business Proposal you should include the follow:
• Problem Statement (In this case, state the purpose)
• Problem Solution (this is where you can describe your tables, how they are related, how they are useful and the purpose of the tables,query, report and form.
• Pricing (Be creative, remember this is a new company with not much capital)
• Why should they choose you over a competitor?
You will submit both the database and the report in blackboard it will be listed under assignments.