American InterContinental University Local Coffee Shop Inventory Discussion

6:16 PM (CT)Unit 2 ­ Individual Project
Assignment Overview
Type: Individual Project
Unit: Database Types & Design Basics
Due Date: Tue,1/4/22
Grading Type: Numeric
Points Possible: 120
Points Earned:
Deliverable Length: Word document, 5 pages
Go To:
Assignment Details
Learning Materials
Reading Assignment
My Work:
Online Deliverables: Submissions
Looking for tutoring? Go to Smarthinking
Assignment Details
Assignment Description
You will create this assignment following the Assignment Detail instructions below.
Review the tutorial How to Submit an Individual Project.
Note: Refer to the learning resources in this unit to help you with this assignment.
For this assignment, you will create an initial design for a relational database. Examples of the purpose for the database could be for a human resources department, a student
management system, a retail inventory system, or any other use you can think of.
Step 1. You will determine the purpose of your database. (e.g., Local Coffee Shop inventory system). Be sure to explain what your database will be doing to support the
organization. Do not just state the organization’s name or type.
Step 2. Determine what types of data your database will store. (e.g., products, prices, vendors, inventory, etc.)
Step 3. Create at least four tables using MS Word or other software to show the columns in each table. If you create the tables in other software, you will need to copy/paste or
insert them into your Word document.
Example of one table:
Item_ID Category Name Vendor Quantity Our_Cost Price
TIPS:
Each table must have a different purpose.
The columns within each table must relate to the purpose of the table.
A table is a thing (e.g. Products)
A column describes a thing (e.g. Cost, Category, Name, etc.)
Each table must have its own primary key (e.g. Item_ID)
Step 4. Fill out 2­3 rows in each of the 4 tables. If you create and add your rows of data to the tables in other software, you will need to copy/paste or insert them into your Word
document.
Paper Outline
A. Title page including the following information:
a.
b.
c.
d.
B.
C.
D.
E.
F.
G.
Student Name
Course code (e.g., ITCO­231)
Unit and assignment (e.g., Unit 2 Individual Project)
Submission date
Page 1 – Explain the purpose of your database and what types of data it will store (Steps 1 & 2).
Page 2 – Table 1 with 2­3 rows of data (Steps 3 & 4).
Page 3 – Table 2 with 2­3 rows of data (Steps 3 & 4).
Page 4 – Table 3 with 2­3 rows of data (Steps 3 & 4).
Page 5 – Table 4 with 2­3 rows of data (Steps 3 & 4).
Reference page (if appropriate)
Paper should be an APA formatted Word document, double­spaced, 5­pages plus the title and reference pages.
Please submit your assignment.
For assistance with your assignment, please use your text, Web resources, and all course materials.
Please submit your assignment.
For assistance with your assignment, please use your text, Web resources, and all course materials.
Grading Rubric
U2 IP Grading Rubric
Reading Assignment
Assignment Objectives
Describe the features of contemporary database models.
Describe the fundamental concepts of database design.
Other Information
There is no additional information to display at this time.
Legend
Extra Credit
View Assignment Rubric