Local Coffee Shop Inventory Discussion-American InterContinental University.

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