COMP 108 Introduction to Databases

I have an assignment due 10/29.

Create a Dentist Database.  See Attached file

 

COMP 108 Introduction to Databases5-1: Pulling it All Together – Dentist’s OfficeDentist Office DatabaseThis database is being created for the receptionist/manager of a dentist’s office. Theoffice has one dental assistant and one dentist.Each performs various procedures andeach procedure has a specific cost.Even though the patient is charged a set fee perprocedure, the dental assistant is paid by the hour and also gets a percentage of theprocedure price per procedure. While a real database would contain a lot moreinformation, this database has been simplified to allow you to concentrate on itsconstruction.It will contain the following information.Table:tblPatientsTable:tblProceduresTable:tblAppointmentsPatient ID (autonumber)Procedure ID (autonumber)Appointment ID (autonumber)Patient Last NameProcedure NameAppt Date (Input Mask)Patient First NameProcedure Price (currency)Patient ID (foreign key)Patient AddressProcedure ID (foreign key)Patient Phone (input mask)Appointment Duration (numberof hours: .5, 1, 1.5, or 2)Patient Age (integer)Emergency Fee ($10-$50)(currency)Patient Copay ($0 if noinsurance, $15-$30 if haveinsurance; currency)Paid (yes/no)Indicator if Patient hasDental Insurance (y/n)Step by Step Description:1.Use all of the naming conventions discussed in this course.2.Set the database to compact on close.3.Create three tables as per specifications above with the proper formatting.4.Set table relationships and referential integrity (including cascade update and cascadedelete if applicable)5.Enter the data into the tables.The tblPatients table should have a minimum of ten patients with one of thembeing you. Half of the patients should not have dental insurance.At least four ofthe patients should be children age 0-16. The rest should be over 16.In the tblProcedures table enter at least eight different procedures (cleaning,crown, filling, root canal, x-ray, etc.) that the dentist and/or dental assistantperforms with a different price for each procedure.0629151 of 3

• 1495070324-projectDentist.doc

SuperTutor

(15)

Status NEW Posted 18 May 2017 01:05 AM My Price 9.00

-----------

Attachments

file 1495070326-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer