Working with Data bases

I need help with a Computer Science question. All explanations and answers will be used to help me learn.

Haven’t Found The Relevant Content? Hire a Subject Expert to Help You With
Working with Data bases
Hire Writer

Unit Outcomes:

  • Break down main ideas into attributes for database organization.
  • Determine how primary and foreign keys connect entities in a relational database.
  • Investigate relational database normalization.
  • Report data breaches through research into real-life scenarios.

Course Outcome:

IT503-3: Appraise database development standards and security issues.

Purpose

This assignment will help you to understand the basic organization of entities in a database and the various levels of normalization. You will also understand that SQL is a typical language used and find where it can be learned. A template is given for this assignment; while APA citation and referencing are required, the format is business-like.

Download and use the template here: Required Unit 4 Assignment 1 Template

Assignment Instructions and Requirements

A recent veterinary school graduate has asked you to put together a database for her new practice. While this assignment will not produce a full plan for a database, you will produce some ideas to discuss with the vet first.

Part 1: Developing Entity Tables

Develop an entity table for one kind of animal client, chosen from this list:

  • Dogs
  • Cats
  • Birds
  • Rodents
  • Reptiles

The top row should be your primary key. The rest of that column should be left blank. Add appropriate attributes for that kind of animal, filling in the attribute name, data type, length, and yes or no for whether or not it is required.

There must be at least 8 attributes (including the primary key). You may add rows for additional attributes if you find it necessary. Some attributes might be binary (yes/no) data types.

Part 2: Normalization

Perform research about database normalization and locate 1-2 appropriate sources for this section. Then write an explanation that your client should be able to understand, and cover the following, each in its own paragraph:

  • Definition of normalization and why it is important. Include an example of what could happen if a database is not normalized.
  • Explanation of 1NF, 2NF, and 3NF.
  • Explanation of Boyce-Codd normal form and a mention that there are other forms as well.

Additional parameters:

  • The overall length for this section must be at least 300 words.
  • Use paragraphing, and write in full sentences, without lists.
  • Cite your source(s) properly using APA rules.

Part 3: SQL Introduction

In this section and in 25-40 words, briefly explain SQL and its uses. Cite your source properly.

Then find an online tutorial for SQL. Include the full URL to the beginning page of the tutorial, placing this under the explanation.

Other parameters

Formatting: You are required to use the given template; download it to your computer, fill it out, save it again, and then submit your work.

  • Do not copy and paste the template content into a new document, change font, or make other changes; use it as it is given to you.
  • Replace “Student Name” with your name, and “Date” with the date you completed your assignment.
  • Since this is a business document, single space the paragraphs in parts 2 and 3. Do not indent the first line of each paragraph, but instead place a blank line between paragraphs. This formatting is easy to read and creates fewer pages for potential printing.
  • Follow instructions both here and in the template itself.

Referencing: Use APA in-text citation in parts 2 and 3 and provide a full APA reference entry for every source used at the end of the document.

Writing: Present all information in this document without first-person writing and without addressing the client directly with “you” or “we.” Simply present the information as factual evidence gathered from research.

superadmin (28431)
New York University
DO YOU HAVE A SIMILAR ASSIGNMENT?

Hire an Expert to Help you

Hire Verified Expert

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Have a homework question? Get help from verified tutors now!

Are You Looking For Assignment Help? We Can Certainly Assist You