Question

Using phpMyAdmin you will create database tables that contain

• Receptionists’ records (20 unique and valid receptionist records)
• Pet Owners records (each receptionist should have at least one pet owner and pet
owners can have a reservation with more than one receptionist)
• Pet Owners reservation records
• Pet Owner’s Additional Perks
The records in each of these tables must contain valid and unique data. Points will be
deducted if data is not valid and unique.
Your database tables should also be normalized.
Your column/field names should be meaningful.
I strongly suggest (especially for those that are new MySQL that when creating your tables
and columns/fields (in your tables) that you create tables and columns/field names that have
no spaces. This alleviates the need for ` ` (tick marks) around table and column/field names
when creating SQL commands. I have found in the past the need for ` ` (tick marks) has
caused many issues for those new to SQL regarding SQL syntax and thus causing errors.
For example: calling a column/field firstname rather than first name is preferable.
Your records will have the following columns/fields associated with a receptionist :
• Receptionist First Name
• Receptionist Last Name
• Receptionist Password
• Receptionist ID Number
• Receptionist Phone Number
• Receptionist Email Address
You will also need information about the Pet Owner.
Your records will have the following columns/fields:
• Pet Owner First Name
• Pet Owner Last Name
• Pet Owner ID
You will also need information about the pet owner’s reservation.
Your records will have the following columns/fields:
• Pet Name and Type
• Pet Owner’s Address and Phone Number
• Check In Date
• Check Out Date
• Pet Owner ID
• Stay ID
Finally, you will need a table for the pet owner’s additional perks requests.
Your records will have the following columns/fields:
• Additional Perks Requested
• Receptionist ID
• Pet Owner ID
• Perks ID
Once the tables are created you are to design a form (how the form looks is up to you but it
must include a HOME button and the buttons should change color when hovered over) that
will allow the user to access your database tables and print out the tables containing the
Receptionist’s records you created, the Pet Owner’s records you created, the Pet Owner’s
reservation records you created and the Pet Owner’s Perks records you created. Styling
should be found in a separate file and linked into your code

Answer 1

Constructing a database with receptionists' records, pet owners' records, reservation records, and additional perks involves creating well-defined, normalized tables and ensuring data is unique and valid. This is coupled with a user-friendly interface design that allows users to interact with and print the database content.

Step-by-step explanation:

Creating a Database for Pet Owner Services

To create a well-structured database that includes tables for receptionists' records, pet owners' records, reservation records, and additional perks, normalization is a crucial step. In phpMyAdmin, you should start by defining these tables with columns that have meaningful and space-free names. For instance, a receptionists table might include columns like receptionistFirstName, receptionistLastName, and receptionistID which uniquely identifies each receptionist. Each receptionist will have at least one linked pet owner, denoted by a petOwnerID in the pet owners table, which can be related to multiple receptionists through reservations. Additional normalization may involve splitting the pet owners' address and phone number into separate columns for clarity and ease of use.

The reservations table would include fields such as petName, petType, checkInDate, checkOutDate, petOwnerID, and stayID, where each stay is given a unique identifier. Lastly, the perks table would include perksRequested, receptionistID, petOwnerID, and perksID to capture any additional services the pet owner requests. It is essential to ensure that all data entered into these tables is unique and valid to maintain the integrity of the database.

After creating the tables, design a user-friendly interface that includes a home button and interactive elements such as hover-over color changes for buttons. Ensure that the styling for this form is kept in a separate CSS file and linked back to your HTML content for clean and maintainable code. Once completed, this form should allow users to print out all the tables with the information you created.