You have been asked to create a database model using MS Visio Database Model Diagram Template. The purpose of

this iLab 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 iLab, 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 iLab 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 (NWind) database will be used again in this iLab.

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. ATTACHMENT PREVIEW Download attachment

Week4_Discussion_Northwind_Database

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"