DATABASE Design and SQL project

For this Project you will need to design and create a database for the following company.
Pampered Pets is a business that started with Bobby Taylor walking dogs and grew to include many
other pet services. Services now include dog walking, playtime, giving medications, transportation, and
pet sitting for mainly dogs but other pets too. Many of his customers have multiple pets. With the growth
of his business the spreadsheet that he is using is becoming difficult to use so Bobby would like to turn it
into a database. The spreadsheet has two worksheets, a “Service Schedule”, and a list of “Service
Use the sample data workbook included in the assignment link to see the way information about
Pampered Pets is currently being kept. Since this is kept by Bobby, you may find errors in this
workbook. These need to be corrected in your database. Hopefully your design will avoid these types of
errors. Be sure to state any assumptions you make about this data.
1. Identify the entities in your database and then create a normalized ERD. The ERD should show the
Entities, Relationships, Minimum and Maximum Cardinalities, Primary and Foreign Keys, and
Attributes. Be sure to state any assumptions you are making.
2. Using your ERD design, make a SCRIPT file that will create the database using Oracle SQL. The
SCRIPT file should also add the data to the database from the workbook. You can either import the
data or enter it manually with the Insert command.
3. Think of the kind of information Bobby could use about Pampered Pets and create at least 4 queries
to gather information from the database. Include these queries in a SCRIPT file.
4. Devise a plan for the security and backup of the database. Because of the nature of this small
business, the plan does not need to be very elaborate. Keep it simple.
5. Provide a written report document that outlines your assumptions, tells why you feel your database
design will work for Pampered Pets, tells why Bobby Taylor needs the queries you created, explains
if he will need additional queries, and includes the security and backup plans you devised to keep his
data safe.
You will need to submit the SCRIPT files to create the database and run the queries, the ERD, the
written report document, and any other files used by your project.
NOTE: If you do this as a group, I only need it to be submitted by one student and it must include
the names of all students in the group.
You will use the discussion forum to tell what you did and how Pampered Pets will benefit from your
database. You will also need to respond to 3 other posts discussing the pros and cons of others
database designs. Everyone MUST participate in the Discussion Board even if you did the Project
as a group.

Don't use plagiarized sources. Get Your Custom Essay on
DATABASE Design and SQL project
Just from $13/Page
Order Essay
Homework On Time
Calculate the Price of your PAPER Now
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.


Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.


Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.


Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.


Revising your paper

Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers