[Solved]Items Covered Include Concurrence 3 Tables Propose Fields Making Tables Including Primary Q37228204

Items to be coveredinclude concurrence on the 3 tables (you propose), fields making upthe tables including the primary key field, and how relationshipsare set between the 3 tables.

The maximum numberof tables allowed is 4. Keep it simple with a solid design andjoins between tables. Be sure each table has its own unique primarykey field. This primary key is entered into another table strictlyfor joining purposes which is why we call it a ‘foreign’ key inthat table.

Goals

Design your DatabaseManagement System

Apply what you’velearned to solve a new problem using a database managementsystem.
The volume is not important but, rather the quality and adhering tothe ‘Grading Rubric’ requirements (specifications).

Trouble thinking of aproject?
> Look at the ‘Case Questions at the end of the chapters in thetextbook.
> Look at a bill you routinely receive. A bill is a ‘report’from a database system. Reverse engineer a database system thatmaybe used to create the bill.
> Create a way to track sales that you make in a small businesslike eBay, lawn mowing, Example tables could be a BUYER, ITEM, andPAYMENT.
> Do you have a collection? Create a system for thecollection.

Create somethinglogical and useful without going to extremes. Apply what you’velearned to creating a useful solution to a problem.

>  Design Review (10points)
Begin work on Individual Case Study (name database’YourLastName_IndividualCaseStudy’

     1. Create 3 tables, enterfields in the tables, attributes for each field, and setrelationships between tables in MS Access.
          Donot enter any records in the tables or create any other objectslike forms, reports, and/or queries.

     2. Have a Design Review withyour Instructor

         Each instructor will let you know method of ‘design view’ ofyour data model.
          Someinstructors may require a virtual one-on-one meeting using softwarelike Skype (not Skype for Business) or WebEx.
Face-to-face course may have the design review one-on-one in theclassroom.

Expert Answer

---

Answer to Items to be covered include concurrence on the 3 tables (you propose), fields making up the tables including the primary… . . .