Interpreting Business Rules – Global Homework Experts

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 This.devry.edu/”>Connect 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

order now

required field length

 

Comments are closed.