Objective:Formulate basic Structured Query Language (SQL) statement to return specific data from a database.Design and implement tables, relationships, forms and reports.

profiledesbar

At this point you have constructed your data model and it meets the definition of 3rd Normal form. You are anxious to implement your model into a database. The next step of the project is to create the database and table structures in Microsoft Access.

 

Using Microsoft Access create the tables and relationships defined in your data model. Your Microsoft Access Database at this point should include the following:

 

The Tables as defined in your Entity Relationship Diagram.The Relationships between the tables.3 Defined Queries. One of the queried needs to be created to show the data from the Many-to-Many relationship (or include three tables) originally identified from the initial requirements.Take a screenshot of the ERD and the Queries.

 

Add the Screenshots to the section in your template titled: The Microsoft Access Database.

 

Update the TOC to reflect the new section.Name the document CS251_<First and Last Name>_IP4.doc.Submit the document and the Microsoft Access database file for grading.

 

    • 6 years ago
    • 30
    Answer(2)

    Purchase the answer to view it

    blurred-text
    • attachment
      kyvn.dot
    • attachment
      kyvn.accdb

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      cs_251_fundamentals_of_database_systems_ip4.accdb