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.