Working with Data bases

Relax! Stop worrying about deadlines and let our professional writers help you. Hire an essay writer helper and receive a professional assignment before your deadline. We provide writing services for all types of academic assignments.


Order a Similar Paper Order a Different Paper

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 

 

 

Great students hand in great papers. Order our essay service if you want to meet all the deadlines on time and get top grades. Professional custom writing is the choice of goal-focused students. Word on the online streets is... we're simply the best!

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper