creating a database

Instructions

This project and all of the content within or linked to it was developed by the University of Wyoming IMGT 2400 Instructors. Used with permission from Mike Doherty, Business Department, University of Wyoming.

Description

Students are introduced to the characteristics and features of relational databases using Microsoft Access to create, build, and implement a relational database; import data from Excel, and create information using multiple table queries with sorting/ordering and derived attributes.

Learning Objective(s)

Using the four steps of the relational database model, students design and build a database by incorporating entity classes and primary keys, using an entity-relationship diagram to show the relationship between entity classes, identifying attributes associated with each entity class, creating the actual database based on imported Excel data, and running queries according to the instructions provided on the database project document.

Project Narrative

This assignment introduces students to database design, building, and creation using Access. The Access skill sets associated with this project include designing and building a relational database, cardinality, and implementing the database using Excel data provided for the project.

Prerequisite Knowledge – Awareness of Microsoft Access as a personal database management systems. Definition and purpose of a database management program. Ability to enter text and data into cells. Insert and delete rows and columns. Ability to look at simple pieces of data and perform operational functions associated with queries (i.e., Quantity*Price = Total Price).
Subsequent Application – Cardinality; entities; entity relationships (Primary/Foreign Keys); attributes; implementing a database; and aggregate functions (sorting, grouping, joining, deriving)

Requirements

For this project, you will be creating a database for the Cowboy Cookie Company. The database will include information on customers, orders, and products. More information can be found here: Cowboy Cookie Company Order Database.

Provide a database design with an Entity Relationship Diagram and an Access Database including the following items: tables that match the E-R Diagram and Field Design (PowerPoint document); create data entry forms to easily input records into your tables; include two of your own products, two customer names (with one record being yours), and two orders; four queries using multiple tables (instructions below); and four reports based on the queries. The data you will be using for this project can be found here: (data).

Using this data, create four queries based on the criteria listed below. Create and name reports to match queries (i.e. Order Date Report, Order Type Report, Product Report, and Total Batch Price Report).

  • Product Query – Create a query that lists all products that start with the letter “O” or start with the letter “B” and whose retail price is between $1.75 and $2.50. Include the product ID, product name, batch size, and price. Create a report using this query sorted by product name.
  • Total Batch Price Query – Create a query that includes product ID, product name, batch size, price (each) and calculate the price per batch with a 10% discount . Create a report using this query sorted by product name.
  • Order Date Query – Create a query that lists all the customers who ordered the product “Holiday Sugar Cookie” between February 1, 2016 and February 15, 2016. Include the customer’s first name, last name, order date, product name, quantity, and retail price. Create a report using this query grouped by last name and sorted by order date.
  • Order Type Query – Create a query that lists all the customers who lived “Off campus” and placed an order for the “Cowboy Cookie”. Include the customer’s first name, last name, email address, location, product name, and the order date. Create a report using this query grouped by customer’s last name and sorted by order date.

Resources

Cowboy Cookie Company Order Database

Design PowerPoint document

Excel data

T5 – Designing Database Applications

T6 – Basic Skills and Tools Using Access 2013

T7 – Problem Solving Using Access 2013

T8 – Decision Making Using Access 2013

Database Tutorials

Overview

Relationships

Queries

Reports and Forms

Work Schedule

Activity

Description

Duration

Download Project/ PowerPoint Documents

Download and save the project document and E-R Diagram Template to student One Drive IMGT2400 folder.

10 minutes

Design database (Part I)

Design database using PowerPoint document

Define Entity Classes and Primary Keys

Define entity classes and primary keys based on background information provided

10 minutes

Establish Business Rules

Establish business rules based on background information

30 minutes

Define Relationships Among Entity Classes

Define relationships among entity classes using an Entity Relationship Diagram (relationships derived from business rules)

30 minutes

Define Attributes for each Entity

Define attributes for each entity using FieldType work sheet in Excel data workbook

20 minutes

Implement the Database (Part II)

Implement database based on project requirements

Create Database

Create the database in ACCESS, build Entity tables and attributes, and import Excel data from Excel workbook into database

30 minutes

Create Forms

Create forms

30 minutes

Add Unique Data

Add customer, product, and order information

20 minutes

Create Queries

Create four queries based on project information provided

30 minutes

Create Reports

Create reports based on queries

30 minutes

Total Time (estimated)

4.0 hours

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.


The post creating a database appeared first on Top Premier Essays.

 
"Is this qustion part of your assignmentt? We will write the assignment for you. click order now and get up to 40% Discount"