I need help completing this ields, and assigning data types to these fields nto

Question

I need help completing this

ields, and assigning data types to these fields nto aiscrete entitics naming t Steps To Success: Level 1 the tables he needs create the discovery phase of database design, Don began brainstorming about to create and which specific fields within those tables are necessary to ure all data required for the desired output he identified. Don created tblEmpl thd (u to create the table design s for the remaining tables in the database by uing the existing and missing data he identified into tables, creating field names and nd naming the ficlds and tables according to the standards he established. On a piece of paper, complete the following: . Plan the Employee and Customer tables needed in the 4Corners Pharmacy database a time consuming process. A the information Don garnered during the discovery phase. Planning each table this database will be tables, challenge yourself to plan other tables fter you complete these two 2. Name the Employee and Customer tables according to their contents and the Leszynski/Reddick naming conventions 3. List the fields in each table 4. Designate data types for each field in each table. 5. Look at the plan you created for 4Corners Pharmacy and look for any missing or incomplete data. What other changes would you suggest making, and why?

Explanation / Answer

1.

-> Customers
-> Drugs
-> Prescriptions
-> Doctors
-> Employees
-> Classes

additional table required (*optional):

-> HealthPlans
-> Clinics

-> Households

-> Refills

-> JobTitles

2. adding prefix table to tbl names. Following are the suggested table names reducing Customers to Customer and so on.

-> tblCustomer
-> tblDrug
-> tbPrescriptions
--> tblDoctor
--> tblEmployee
->tblClass
-> tblHealthPlan
-->tblHousehold
-->tblClinic
-->tblJobTitle
-->tblRefill

3.

--> tblCustomer : CustomerID, CustomerFirstName, CustomerLastName, PhoneNumber, DateOfBirth, Gender, Balance, ChildCap, PlanID, HouseID, HeadHH, and Allergies

-->tblEmployee : EmployeeID, EmployeeFirstName, EmployeeMiddleName, EmployeeLastName, SocialSecurityNumber, DateOfBirth, StartDate, EndDate, Address, City, State, ZIP, Comments, Phone, Cell, Salary, HourlyRate, and ReviewDate

--> tblDrug : UPNCode, DrugName, DrugGeneric, DrugDescription, DrugUnit, DrugDosage, DosageForm, DrugCost, DrugPrice, Interactions,PregCategory, and Supplier

-->tblPrescription : PrescriptionID, UPNCode, PrescriptionQuantity, PrescriptionUnit, Date, ExpireDate, Refills, AutoRefill, RefillsUsed, Instructions, CustomerID, and DoctorID

--> tblDoctor : DoctorID, DoctorFirstName, DoctorLastName, PhoneNumber, CellNumber, and ClinicID

--> tblClass : ClassID, Description, Cost, Renewal, Required, and Provider I

--> tblHealthPlan : PlanID, PlanName, Address, City, State, ZIP, PhoneNumber, Days, and WebSite

--> tblHousehold : HouseID, Address, City, State, and ZIPCode

--> tblClinic : ClinicID, ClinicName, Address, City, State, ZIPCode and PhoneNumber

--> tblJobTitle: JobID and Title
--> tblRefill: PrescriptionID, RefillDate, and EmployeeID

4.

--> tblCustomer :

CustomerID-> Number,

CustomerFirstName-> Short Text,

CustomerLastName-> Short Text,

PhoneNumber-> Short Text

DateOfBirth->Date/Time,

Gender->Short Text,

Balance->Number,

ChildCap->yes/no

PlanID->Short Text,

HouseID->Number,

HeadHH->Short Text, and

Allergies->short Text

-->tblEmployee :

EmployeeID->Number,

EmployeeFirstName->Short Text,

EmployeeMiddleName->Short Text,

EmployeeLastName->Short Text,

SocialSecurityNumber->Short Text,

DateOfBirth->date/time,

StartDate->date/time,

EndDate->date/time,

Address->short text,

City->short text,

State->short text,

ZIP->short text,

Comments->->short text,

Phone->short text,

Cell->short text,

Salary->currency,

HourlyRate->currency, and

ReviewDate->date/time

--> tblDrug :

UPNCode-->number,

DrugName->short text,

DrugGeneric->short text,

DrugDescription->short text,

DrugUnit->number,

DrugDosage->short text,

DosageForm->short text,

DrugCost->currency,

DrugPrice->currency,

Interactions->short text,

PregCategory->short text, and

Supplier->short text

-->tblPrescription :

PrescriptionID->number,

UPNCode,->number

PrescriptionQuantity->number,

PrescriptionUnit->number,

Date->date/time,

ExpireDate->date/time,

Refills->number,

AutoRefill->yes/no,

RefillsUsed->number,

Instructions->short text,

CustomerID->number, and

DoctorID->number

--> tblDoctor :

DoctorID->number,

DoctorFirstName->short text,

DoctorLastName->short text,

PhoneNumber->short text,

CellNumber->short text, and

ClinicID->number

--> tblClass :

ClassID->number,

Description->short text,

Cost->currency,

Renewal->yes/no,

Required->yes/no, and

Provider->short text

--> tblHealthPlan :

PlanID->number,

PlanName->short text,

Address->short text,

City->short text,

State->short text,

ZIP->short text,

PhoneNumber->short text,

Days->number, and

WebSite->short text

--> tblHousehold :

HouseID->number,

Address->short text,

City->short text,

State->short text, and

ZIPCode->short text

--> tblClinic :

ClinicID->number,

ClinicName->short text,

Address->short text,

City->short text,

State->short text,

ZIPCode->short text and

PhoneNumber->short text

--> tblJobTitle:

JobID->number and

Title->short text
--> tblRefill:

PrescriptionID->number,

RefillDate->date/time, and

EmployeeID->number

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.