Question;Lab 4a of 7: Database Design Based on Data Requirements and Business Rules Focusing on Interpreting Business Rules to Determine RelationshipsiLab 4b of 7: Completing QueriesNote!Submit your assignment to the Dropbox located on the silver tab at the top of this page.(See the Syllabus section "Due Dates for Assignments & Exams" for due dates.)Remember ThisConnect to the iLab here.iLAB OVERVIEWScenario and SummaryPart A: 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.Upon completing this lab, you will be able to:create a new Visio file for database design, andusing the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths.Part B: The lab begins with a simple example of query development using Access, then, evolves to more complex queries which the student should perform after completing the first exercise. Create a query using the wizard with query-design view or with SQL statements. The Northwind database will be used again in this lab.Upon completing this lab, you should be able to:create a query by following lab instruction,create a query by using either Query Designer or Query Wizard,create a query by using SQL statements, andinterpret the results of queries.DeliverablesPart A: Step 6: YourNameLab4A.vsd (Visio Diagram)Part B: Step 7: YourName_Lab4B_Finital.accdb (Access Database)iLAB STEPSA. Lab #: BSBA BIS245A-4A;B. Lab 4A of 7: Database design based on data requirements;and business rules;focusing on interpreting business rules to determine;relationships.;C. Lab Overview --Scenario/Summary;TCO(s);1. Given a business situation in which managers require;information;from a database, determine, analyze and classify that;information;so that reports can be designed to meet the requirements.;2. Given a situation containing entities, business rules;and data;requirements, create the conceptual model of the database using;a;database modeling tool.;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.;Upon completing this lab, you will be able to;1. create a new Visio file for database design, and;2. using the data requirements and the business rules;provided, develop;a conceptual model (ERD), including attribute data types and;required field lengths.
Paper#54438 | Written in 18-Jul-2015Price : $26