Creating your own tables and database | Homework Help Online

CREATING A DATABASE

​​​​​Instructions

Imagine that you have just been hired by a veterinary clinic to help them build a database of their clients.  It is important that you build a database that will be easy for their systems to query, as well is efficient to administer.  Overall, this assignment will provide you with an opportunity to apply all that you have learned about MySQL in this course to a real-world job situation.

For this assignment, you will be creating your own tables and database to the job requirements provided.  To start, perform the following operations:

  1. Create a table called Customers.
    • Create at least five fields to have human customer name (pet owner). This should have a CustomerID as a primary key and fields to store the customer information.
  1. Create a table called Animals.
    • Create at least five fields to have animal/pet information. This should have an AnimalD as a primary key and fields to store the pet information. Also, have the CustomerID and AnimalTypeD as foreign keys.
  1. Create a table called AnimalTypes.
    • Create at least five fields to have animal type information (example: Dog, Cat, Bird). This should have an AnimalTypeD as a primary key and fields to store the animals type information.
  1. Create five test records for each table.
  2. Create a query to display all the data for the following report (note: You will have to join all the tables to get this query): Pet Name, Customer First Name, Customer Last Name, Address, Animal Type (name of species).
  3. For all of the above, make sure you include subsections that include:
    • The SQL statement to run the report.
    • Screenshots of the three table schemas/structures.
    • The report with the data.
  1. Additionally, write 4–8 paragraphs, using at least one resource to support your writing, in which you address the following:
    • Summarize the approach you took to create the database.
    • Describe any issues you have creating the database and the steps you took to resolve them.
    • Describe improvements that could be made to the database.
    • Reflect on what you learned through this assignment about the professional role and responsibilities of a database administrator.

 

Submission Requirements

  • Written communication: Written communication is free of errors that detract from the overall message.
  • APA formatting: Resources and citations are formatted according to current APA style.  See Evidence and APA for more information.
    • This includes an APA-formatted title page that contains course, your name, date, instructor name.
  • Number of references: Cite at least one credible and relevant resources to support your work.
  • Length of paper: 3 pages, excluding the title and references pages.
    • Subsections should include:
      • One for your SQL statements.
      • One for your screen shots.
    • 4–8 written paragraphs addressing the assignment prompts.
  • Font and font size: Times New Roman, 12-point.

 

Do My paper price
Pages (550 words)
Approximate price: -

Why Essay-writing.com

Quality Research Papers

If you’re looking for an Essay writing service to help turn all of your hard work into a product that readers can appreciate, then look no further than our essay writing website. With a team of writers who go the extra mile, and customer support representative’s around-the-clock eager to assist you, we are ready to ace any exam or provide any posterity with what they need.

Top Assignment Writers

Our essay writers are experienced professionals who have the knowledge to write an essay about any subject matter in an interesting way while maintaining academic integrity. Our professional essay writers work day and night to ensure that you receive quality essays on time without any delay or interruption. Looking to "pay someone to do my assignment"? With many years of experience behind us, our essay writing website is now led by professionals with extensive knowledge in various fields of study.

Zero Plagiarism

For any write my essay for me request, you will never need to worry about plagiarism or getting caught up in the stress of completing assignments when you use our professional services! Get started today by ordering your first paper from us and we'll give you 10% off!

24/7 Customer Support

We are available 24/7, 365 days a year to help you out with your academic needs! if you have any "do my paper" questions or technical concerns, simply chat with one of our essay writing customer service representatives via the Chat Window on the bottom right corner of this screen

Prompt Delivery and 100% Money Back Guarantee

These academic experts are distinct from most other essay writing websites because they have doctoral degrees and decades of professional experience in academia. And because they know how overwhelming college life can be, we waive all minimum deadlines so you can focus on studying without worrying about your assignment always hanging over your head.

Free Revisions

Our Academic writers are confident and highly capable to take on any challenge ranging from a simple high school essay, question and answer assignment help, PowerPoint Presentation, research paper, dissertation, among others . However, we do not allow customers who abuse the free revisions privilege.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your "pay for essay" order

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

Proceed with the payment

Choose the payment system that suits your "do my homework" request

Receive the final file

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

Our Services

When the world rushes and deadlines increase, it's hard to put your best foot forward. The Homework help website is here to help you with top quality essays on all topics, from history papers and engineering design descriptions to sociology case studies. For any write my essay for me request, you can count on a professional team of essay writers who are well experienced and researched in their field as they develop an original paper for you with 24/7 customer support.

Essays

Homework Help Service

The assignment help website is an excellent solution for all your problems regarding writing an outstanding admission essay. You don't need to worry about anything anymore because we will provide you with high-quality papers written by expert writers who know how to write professionally!

Admissions

Paper Formats and Types

From time management skills to APA format citations; from MLA formatting rules for research papers; from college application essays where the stakes are high--all these aspects of academic life become clearer as we write it all down on paper! Essay-Writing.com is a professional essay writing service that provides students with well-researched, high quality essays on any topic and at any level of study.

Reviews

Editing & Proofreading

Some of our clients prefer to write their essays themselves and have a third-party like Essay-writing.com proofread it for errors after they are done writing. We have a skilled team of editors and assignment helpers assignment helpers who examine your paper closely, looking out for any mistakes that may lessen the appeal or effectiveness of the essay as well as make amends in order to better improve its overall quality before you submit it anywhere else! For all your editing needs, turn to Essay-writing.com

Reviews

Revision Support

You work hard at your academics, and you should be rewarded, with a revision or modification for free on any order from a discursive essay , assignment to dissertation papers.

AllEscort