BIS245 ilab Week 5

$17.50

BIS245 ilab Week 5
You have been asked to create a database model using the MS Visio Database Model Diagram…

SKU: BIS 245 You have been asked to create database model Categories: , Tags: , , ,

Description

BIS245 ilab Week 5

BIS245 ilab Week 5

A+ 

Scenario/Summary

You have been asked to create a database model using the MS Visio Database Model Diagram Template. The purpose of this lab is to provide experience normalizing the database to third normal form based on limited instructions, data requirements, and associated business rules.

The lab begins with creating a form in Access using the Form Wizard. After the form is created, the user can use themes to change the appearance of the form. The second part of the lab uses form design to create a form. Finally, the form will be customized.

Upon completing this lab, you will be able to

  • create a new Visio file for database design; and
  • using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths.
  • create a form using form design; and
  • create a form using the form wizard.

Deliverables

  • Step 1:docx
  • Step 3:vsdx (Visio Diagram)

Step 5: YourName_Lab5B_Final.accdb (Access Database)