1 / 2

BIS 245 Week 3 iLab Devry

Just Click on Below Link To Download This Course:<br>https://www.devrycourses.com/product/bis-245-week-3-ilab-devry/<br>BIS 245 Week 3 iLab Devry <br>A.Lab # : BSBA BIS245A-3<br>B.Lab 3 of 7:Database Design Using Visio and Based on Data Requirementsand Business Rules<br>C.Lab Overviewu2013Scenario/Summary<br>TCOs:<br>2.t2.Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.<br>3.t3.Given an existing relational database schema, evaluate and alter the database design for efficiency.<br>

devrycourses
Download Presentation

BIS 245 Week 3 iLab Devry

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BIS 245 Week 3 iLab Devry Just Click on Below Link To Download This Course: https://www.devrycourses.com/product/bis-245-week-3-ilab-devry/Or Email us help@devrycourses.com BIS 245 Week 3 iLab Devry A.Lab # : BSBA BIS245A-3 B.Lab 3 of 7:Database Design Using Visio and Based on Data Requirementsand Business Rules C.Lab Overview–Scenario/Summary TCOs: 2.2.Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. 3.3.Given an existing relational database schema, evaluate and alter the database design for efficiency. 4.4.Given an existing database structure demonstrating efficiency and integrity, design the physical tables. Scenario You have been asked to create a database model using MS Visio Database Model Diagram Template. The purpose of this lab is to provide experience designing, with limited instructions, a simple database based on a list of data requirements and associated business rules. You will then complete an MS Access database based on the model developed in Visio, creating the necessary tables and relationships. Upon completing this lab, you will be able to 1.1.create a new Visio file for database design; 2.2.using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths; and 3.3.create a new MS Access database based on the ERD. 4.D.Deliverables Section Deliverable

  2. Part A Step YourNameLab3.vsd (Visio Diagram) 7 Part B Step YourNameLab3.accdb (Access Database) 3 Download File Now

More Related