Details of this Paper

DEVRY BIS245 WEEK 4 iLAB 4

Description

solution


Question

Lab 4a of 7: Database Design Based on Data Requirements and Business Rules Focusing on Interpreting Business Rules to Determine Relationships;iLab 4b of 7: Completing Queries;Note!;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 This;Connect to the iLab here.;iLAB OVERVIEW;Scenario and Summary;Part 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, and;using 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, and;interpret the results of queries.;Deliverables;Part A: Step 6: YourNameLab4A.vsd (Visio Diagram);Part B: Step 7: YourName_Lab4B_Finital.accdb (Access Database);iLAB STEPS;A. 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#30288 | Written in 18-Jul-2015

Price : $41
SiteLock