Fundamentals of Database Systems Key Assignment

Only available on StudyMode
  • Download(s) : 538
  • Published : October 15, 2012
Open Document
Text Preview
Key Assignment Project
Fundamentals of Database Systems
CS251-1202B-03
June 25, 2012

Table of Contents
Project Outline4
Description of the Database Design Life Cycle (Phase 1 IP)4
Selected Database Description4
Tablet and Capsule Antibiotics4
Powder and Liquid Antibiotics5
Skin and Coat5
A Listing And Description Of The 7 Steps Of The SDLC/DBDSL and Their Tasks6
System Requirements Analysis and Feasibility Study6
System Analysis7
Code Generation and Design9
Implementation9
Testing9
Maintenance10
A Description Of The 3 Steps In Database Creation11
(Including Conceptual, Logical, And Physical Data Modeling)11
As It Relates To My Selected Database14
Conceptual Model14
Logical Model14
The Entity Relationship (Phase 2)15
The Logical Model and Normalization (Phase 3 IP)16
Logical Data Model17
Customer17
Medications18
Orders18
Shipping19
Medication_Items19
Normalization to 3rd Normal Form19
(Revised)19
The Microsoft Access Database (Phase 4 IP)22
Queries23
Customer_Phone_Query23
Medications_Items_Query (Many2Many)23
Medication_Orders_By_State_Query24
Customer_Eamil_Query24
Forms25
Customer_Email_Form25
Customer_Form25
Medications_In_Stock_In_June_2012_Form26
Medication_Items_Form (Many2Many)26
Reports27
Relationships_Report27
Medication_Shipping_Dates_Report27
Medications_In_Stock / June_2012_Report28
The Microsoft Access Database Application (Phase 5 IP)29
Menus29
References32

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 shipping and handling charge. Products available include (but are not limited to) the following: Tablet and Capsule Antibiotics

1) Ampicillin Capsules - 250 mg. strength - 100 capsules -  $31.98 + S&H 2) Amoxicillin Capsules - 250 mg. strength - 100 capsules -  $16.98 + S&H 3) Amoxicillin Capsules - 500 mg. strength - 100 capsules -  $28.50 + S&H 4) Cephalexin Capsules - 250 mg. strength - 100 capsules -  $25.50 + S&H 5) Cephalexin Capsules - 500 mg. strength - 100 capsules -  $43.98 + S&H 6) Ciprofloxacin Tablets - 250 mg. strength -100 Tablets - Fish Flox -  $32.99 + S&H 7) Ciprofloxacin Tablets - 500 mg. strength - 30 Tablets - FishFlox Forte -  $23.50 + S&H Powder and Liquid Antibiotics

1) Amoxicillin Capsules - 250 mg. strength - 100 capsules -  $16.98 + S&H 2) Albon Generic - Sulfadimethoxine Powder - 107 gm. -  $18.89 + S&H Concentrated Sulfadimethoxine powder generic to Albon - Sulfadimethoxine powder 107 gm.

3) Biosol Generic - Neomycin Antibiotic Solution - 16 oz. -  $14.99 + S&H Skin and Coat

1) All-In-One Vitamin/Mineral Powder - 13 oz. -  $12.99 + S&H NaturVet Naturals All-In-One is the ideal product for your pet's essential needs - combination of 43 vitamins and minerals help your pet maintain healthy digestion, skin, coat, and joints 

2) Allerg-3 Fatty Acid Caps - Small 10 - 30 lb. - 60 caps -  $25.89 + S&H Concentrated, liquid fatty acid capsules - A supplementary source of Omega-3 Fatty Acids where dietary intake is inadequate or when the skin and coat condition indicate that supplementation would be of benefit to the animal

Veterinary orders will be tracked by veterinarian name, address, phone number, item name, number of items ordered, date ordered and date received.

A Listing And Description Of The 7 Steps Of The SDLC/DBDSL and Their Tasks

Everything in this life starts with an idea; and...
tracking img