Sign In
Not register? Register Now!
Essay Available:
Pages:
2 pages/≈550 words
Sources:
3 Sources
Level:
APA
Subject:
Technology
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 10.8
Topic:

Database Technology and Database Administration (Essay Sample)

Instructions:

In this assignment, you are to use what you have learned about normalization to improve Trident Student database design. Following are your tasks:

  1. Normalize the tables you have designed in Module 2. Explain how you redesign your tables to satisfy the requirements of 1NF, 2NF and 3NF. When necessary, it is perfectly okay to create another table. If you believe your tables designed in Module 2 already met the normalization requirement, explain why.
  2. Modify the database you created in Module 3: drop the tables that you have redesigned for normalization, and keep those that are intact.
  3. Create new tables as required in your new design, using SQL in DBMS.

Include the SQL statements and screenshots of your new tables in the paper.

SLP Assignment Expectations

  • Create tables that met normalization standards.
  • Use SQL to create and drop tables.
source..
Content:
Trident University
DATABASE IMPLEMENTATION-SLP 3
Name
Course: ITM 440 Database Technology and Database Administration
Instructor
Date
In designing the database, there is a need to take into account normalization, as this breaks down the constituent parts into manageable components. The final representation ought to show only one unique thing that characterizes the table, with columns to describe the unique ‘things’ (Davidson, 2007). Normalization allows data users to assess whether the there is good performance and development. Even though, there is no agreement on the level of normalization, the 3rd Normal Form is typically the main level of normalization, but the 4th and 5th levels can also be necessary (Davidson, 2007).
The previous tables have met the requirement of normalization in the 2rd normal form, but there appears to be transitive dependency, while the relationship also satisfies the first normal form. The 3rd normal formal is not satisfied since the student information table needs to be split to show the contact information and location information separately. The process of normalization is necessary to avoid updating anomalies while also avoiding unnecessary coding. In any case, placing the data into the forms makes it easier to accommodate any changes accurately. According to Chopra (2010), normalization frees relations from undesirable insertion, updates as well as deletes anomalies.
The need to eliminate redundant data while storing related data is a top priority in the normalization process. The rationale for this is t...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

Other Topics:

  • Value Chain and Porters Forces
    Description: Value chains can be used to determine how a firm is fairing relative to its competition and can also be used specifically to create competitive advantage...
    4 pages/≈1100 words | 5 Sources | APA | Technology | Essay |
  • Database Implementation-Case
    Description: This is an attempt to normalize the data in order to make the tables more efficient in line with the need to improve the database...
    2 pages/≈550 words | 3 Sources | APA | Technology | Essay |
  • Discussion-Business Intelligence
    Description: A business intelligence system is a set of tools and processes that helps businesses make decisions that need a lot of critical, technical and professional analysis...
    1 page/≈275 words | 2 Sources | APA | Technology | Essay |
Need a Plagiarism Free Essay?
Submit your instructions!