Fundamentals of Database Systems Key Assignment

Key Assignment Project
Fundamentals of Database Systems
CS251-1202B-03
June 25, 2012

Table of Contents Project Outline 4 Description of the Database Design Life Cycle (Phase 1 IP) 4 Selected Database Description 4 Tablet and Capsule Antibiotics 4 Powder and Liquid Antibiotics 5 Skin and Coat 5 A Listing And Description Of The 7 Steps Of The SDLC/DBDSL and Their Tasks 6 System Requirements Analysis and Feasibility Study 6 System Analysis 7 Code Generation and Design 9 Implementation 9 Testing 9 Maintenance 10 A Description Of The 3 Steps In Database Creation 11 (Including Conceptual, Logical, And Physical Data Modeling) 11 As It Relates To My Selected Database 14 Conceptual Model 14 Logical Model 14 The Entity Relationship (Phase 2) 15 The Logical Model and Normalization (Phase 3 IP) 16 Logical Data Model 17 Customer 17 Medications 18 Orders 18 Shipping 19 Medication_Items 19 Normalization to 3rd Normal Form 19 (Revised) 19 The Microsoft Access Database (Phase 4 IP) 22 Queries 23 Customer_Phone_Query 23 Medications_Items_Query (Many2Many) 23 Medication_Orders_By_State_Query 24 Customer_Eamil_Query 24 Forms 25 Customer_Email_Form 25 Customer_Form 25 Medications_In_Stock_In_June_2012_Form 26 Medication_Items_Form (Many2Many) 26 Reports 27 Relationships_Report 27 Medication_Shipping_Dates_Report 27 Medications_In_Stock / June_2012_Report 28 The Microsoft Access Database Application (Phase 5 IP) 29 Menus 29 References 32

Project Outline
Description of the Database Design Life Cycle (Phase 1 IP)
Selected Database Description

The selected database I have chosen for this project will be that of a veterinary medical supply database and the veterinarians who order medications from that database. I will track what is ordered and shipped to the veterinarians. This is an online veterinary supply, so, all medications will be mailed (or shipped) to the customer with a

References: 1KeyData. (2012). Data Warehousing > Concepts > Conceptual, Logical, And Physical Data Models . Retrieved May 23 2012, from Conceptual, Logical, And Physical Data Models: http://www.1keydata.com/datawarehousing/data-modeling-levels.html Ali, A.-R Ambler, S. W. (2002-2011). Data Modeling 101. Retrieved 2012, from Agile Data: http://www.agiledata.org/essays/dataModeling101.html Arhun.com Centers for Disease Control and Prevention. (2004, May 23). Public Health Information Network Logical Data Model Version 1.0 User Guide. Retrieved May 26, 2012, from http://www.cdc.gov/phin/library/archive_2005/PHIN_LDM_User_Guide_v1.0.pdf Cisco Systems Coulson, F. (n/d). Retrieved June 10, 2012, from PHLONX: https://campus.ctuonline.edu/pages/MainFrame.aspx?ContentFrame=/Home/Pages/Default.aspx Datatrend Technologies, Inc G C & E Systems Group. (2012). Security Lead Technician. Retrieved June 11, 2012, from http://www.gcesg.com/careers/sec-tech/ Microsoft Newark Jobs Connect. (n/d). Data Center Technician - Rack Team, Sterling VA. Retrieved June 10, 2012, from Newark Jobs Connect: http://newark.tweetmyjobs.com/job-listings/8824679 Open Learn Lab Space P2C2 Group, Inc. (2008). BETTER PROGRAMS & PROJECTS. Retrieved June 9, 2012, from P2C2 Group, Inc: http://www.p2c2group.com/jun08nws.html Parlin, T Santa Rosa Junior College. (n/d). Network Technician Description. Retrieved June 9, 2012, from http://www.santarosa.edu/hr/JobDesc-Classified/Network%20Technician.pdf Sjobs Taleo. (n/d). Principal IT Strategy Consultant. Retrieved June 10, 2012, from https://ciber.taleo.net/careersection/pro_orig/jobdetail.ftl?job=175010&src=JB-10180&utm_source=Indeed&utm_medium=organic&utm_campaign=Indeed UNC Charlotte, NC