Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

assume you are in school full time and are starting a part-time side business. You will need to create a database for your part-time concierge

assume you are in school full time and are starting a part-time side business. You will need to create a database for your part-time concierge service. Examples of specialty services include pet sitting, house sitting, running errands, grocery shopping, etc. You need to design your database for this business. You will need at least five entities with attributes.Using Microsoft Access, perform the following tasks:

  1. Create a database and at least five tables along with the appropriate attributes to meet the needs of the business case above.
  2. In your database, you will need to show that you have added ten customers, ten specialty services, and have performed 25 services for customers in the past month.
  3. Create at least five forms to get data into your database.
  4. Create a report to show monthly activity.
  5. Run your report before and after adding new customers to test functionality. (Get a screenshot of the report before you add more records.)
  6. Add subtotals and totals into your report.
  7. Be sure to set up the correct relationship types between the tables: 1:M, 1:1, M:1, M:M.
  8. Be sure to include referential integrity constraints.
  9. Using your diagramming tool of choice, diagram your database table and the relationships between the tables.
  10. Save the database with all objects and save with filename customer_sales.accdb.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data Concepts, Theories, And Applications

Authors: Shui Yu, Song Guo

1st Edition

3319277634, 9783319277639

Students also viewed these Databases questions

Question

1. How will you, as city manager, handle these requests?

Answered: 1 week ago