Page1 of 6A. Lab # : BSBA BIS245A-3B. Lab 3 of 7:Database Design Using Visio and Based on Data Requirementsand Business RulesC
Hi there, please help me with this homework….see the attached instruction.Thank you.
ATTACHMENT PREVIEW Download attachmentPage1 of 6A. Lab # : BSBA BIS245A-3B. Lab 3 of 7:Database Design Using Visio and Based on Data Requirementsand Business RulesC. Lab Overview—Scenario/SummaryTCOs:2. Given a situation containing entities, business rules, and datarequirements, create the conceptual model of the database using adatabase modeling tool.3. Given an existing relational database schema, evaluate and alter thedatabase design for eFiciency.4. Given an existing database structure demonstrating eFiciency andintegrity, design the physical tables.ScenarioYou have been asked to create a database model using MS Visio Database ModelDiagram Template. The purpose of this iLab is to provide experience designing,with limited instructions, a simple database based on a list of data requirementsand associated business rules.You will then complete an MS Access database based on the model developed inVisio, creating the necessary tables and relationships.Upon completing this lab, you will be able to1. create a new Visio file for database design;2. using the data requirements and the business rules provided, develop aconceptual model (ERD), including attribute data types and required fieldlengths; and3. create a new MS Access database based on the ERD.D. DeliverablesSectionDeliverablePointsPart AYourNameLab3.vsdx (Visio Diagram)Part BYourNameLab3.accdb (Access Database)E. Lab Steps
View the AnswerLabPart A: Create a Visio ERD from Data Requirements and BusinessRulesStep 1:Open Visioa. Open Microsoft OFce, Visio application, orb. if you are using Citrix, click on Microsoft OFce Applications folder to startVisio.Step 2:Identify and Create the Entities1. Open a new blank Database Model Diagram. If you need assistance withthis, refer to the Week 1 Lab Instructions. Be sure that all options are setconsistent to those used in previous weeks so that you generate your modelin Crow’s ±oot notation.2. Save the ²le as YourName_Lab3.vsdx.3. Based on the information provided below, create the necessary entities forthe Pages in Time database. If you need assistance to create the entities,refer to iLabs from Weeks 1 and 2.Pages in TimePages in Timeis a small bookstore carrying a variety of books. Theowners have decided to computerize the books available through thestore so that they can determine more easily what books are onhand and which books need to be special ordered to meet customerneeds. Because customers do not always remember the name of adesired book, the owners want to be able to look for books by author orby type (genre). They also want to be able to ²nd the publisher’sinformation using the system so that they can order books more easily.After visiting with the owners, you have gathered the followinginformation on data requirements and business rules to develop aconceptual design (ERD), prepare it for conversion to an Accessdatabase, and then create the actual database.
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
