Chat with us, powered by LiveChat Identify the entities in your database and then create a normalized ERD. | WriteDen

Identify the entities in your database and then create a normalized ERD.

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 Types”. 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. PROJECT REQUIREMENTS: 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. WHAT TO PUT IN THE ASSIGNMENT LINK: 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. DISCUSSION BOARD: 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.

HOW OUR WEBSITE WORKS

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of 
HIGH QUALITY & PLAGIARISM FREE.

Step 1

To make an Order you only need to click ORDER NOW and we will direct you to our Order Page at WriteDen. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
 Deadline range from 6 hours to 30 days.

Step 2

Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Discounts

Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.