1: The front desk receptionist will be creating new appointments upon customer requests. In order to schedule appointments effectively the receptionist needs to know what appointments are already schedule for a given week. The scheduling system will provide a start date to search for the week, the date provided will be a Sunday. Appointments retrieved should be through Saturday. The appointment needs to show the start and end times, the dentist name, and assistant name. The scheduling system will show a calendar view of the appointments for the given week. Create a Query that should return the requested information. 2: Before a bill is sent to a customer it first needs to be sent to Insurance. This test case will prove that the database design can produce the proper billing information. In order to submit an insurance claim a bill will be created which shows the Patients information, each active insurance with contact information, along with a list of the services for the appointment and cost. The billing department can then contact each insurance company to determine their coverage. The covered amount will be updated and a final bill sent to the customer if a balance remains. Create a Query that should return the requested information. 3: A central computer screen will be mounted in an employee area near the treatment rooms for the assistants and dentists to see what the current days schedule is. The schedule needs to show all appointments by time, listing the patients name, dentists name, and assistants name. Create a Query that should return the requested information.
1:
The front desk receptionist will be creating new appointments upon customer requests. In order to schedule appointments effectively the receptionist needs to know what appointments are already schedule for a given week. The scheduling system will provide a start date to search for the week, the date provided will be a Sunday. Appointments retrieved should be through Saturday. The appointment needs to show the start and end times, the dentist name, and assistant name. The scheduling system will show a calendar view of the appointments for the given week.
Create a Query that should return the requested information.
2:
Before a bill is sent to a customer it first needs to be sent to Insurance. This test case will prove that the
Create a Query that should return the requested information.
3:
A central computer screen will be mounted in an employee area near the treatment rooms for the assistants and dentists to see what the current days schedule is. The schedule needs to show all appointments by time, listing the patients name, dentists name, and assistants name.
Create a Query that should return the requested information.
4:
Make your own for the 4th query. Use comment lines in your script to define what the test case should accomplish.
5:
Now that you are confident in the design of your database it is time to develop the initial creation script. In MySQL Workbench use a new sql script tab to develop your script. Your script should include:
Comment block at top showing What, Who, and When
CREATE and USE statements for the database
CREATE statements for each table
- Make sure proper data types and Primary Keys are defined
- Make sure Foreign Key fields are added to the tables but do not specify any Foreign Key Constraints (We will learn about them later and apply when needed). Adding them now will cause errors on your data insert scripts in the next Module.
Insert statements for any known information provided depending on your topic (such as services)
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
