Solution-Normalization of database tables

Normalization of database tables

Assignment Help C/C++ Programming

Reference no: EM13859378

Normalization of Database Tables

Using the STUDENT table structure shown in Table, do the following:

Table: Sample STUDENT Records

Attribute Name	Sample Value	Sample Value	Sample Value	Sample Value	Sample Value
STU_NUM	211343	200128	199876	199876	223456
STU_LNAME	Stephanos	Smith	Jones	Ortiz	McKulski
STU_MAJOR	Accounting	Accounting	Marketing	Marketing	Statistics
DEPT_CODE	ACCT	ACCT	MKTG	MKTG	MATH
DEPT_NAME	Accounting	Accounting	Marketing	Marketing	Mathematics
DEPT_PHONE	4356	4356	4378	4378	3420
COLLEGE_NAME	Business Admin	Business Admin	Business Admin	Business Admin	Arts & Sciences
ADVISOR_LNAME	Grastrand	Grastrand	Gentry	Tillery	Chen
ADVISOR_OFFICE	T201	T201	T228	T356	J331
ADVISOR_BLDG	TorreBuilding	TorreBuilding	TorreBuilding	TorreBuilding	JonesBuilding
ADVISOR_PHONE	2115	2115	2123	2159	3209
STU_GPA	3.87	2.78	2.31	3.45	3.58
STU_HOURS	75	45	117	113	87
STU_CLASS	Junior	Sophomore	Senior	Senior	Junior

a. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all transitive dependencies.

b. Write the relational schema and draw the dependency diagram to meet the 3NF requirements to the greatest extent possible. If you believe that practical considerations dictate using a 2NF structure, explain why your decision to retain 2NF is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions.

Using the results of (b) Specify each table with necessary attributes, their type and size. Identify primary key

Reference no: EM13859378

Questions Cloud

Identify which of the swot factors are most critical : List the specific strengths, weaknesses, opportunities and threats present in the case and Identify which of the swot factors are most critical to the organization's on going success and why

Compare the web pages of the world trade organization : Compare the Web pages of the World Trade Organization (www.wto.org) and other organizations that advocate free trade with the Web pages of the Trade Observatory.

Prepare income statement and a statement of owners equity : Prepare an income statement, a statement of owners equity, and a balance sheet - Post the adjusting entries to the ledger, inserting balances in the accounts affected. Leave the ITEM column blank.

Developing a database to manage academic issues : What's A Matter University (good old Whatsamatter U) is developing a database to manage academic issues. You are asked to assist in the design of the database. Sketch the Entity-Relationship diagram for each of the following business needs. Your a..

Normalization of database tables : Using the STUDENT table structure shown in Table, do the following: Table: Sample STUDENT Records

What can be done to mitigate risks you have identified : Describe what can be done to mitigate the risks you have identified? The submission should be about 1000 words in length and be sure that you include material from at least 3 academic sources to support your position.

Problem regarding the database systems : To develop a database for the given case study by drawing the EER diagram-To apply the normalization rules to the data structures and hence to show the UNF, INF, 2NF, and 3NF relations of the given scenario-To create and manipulate database.

Write an opinion essay about organizational authority : Write an opinion essay about Organizational Authority

Article on accountants committing fraud in ais : Finding an article on accountants committing fraud in Accounting Information System (AIS). Please review the attachment for the full description

User Account

All Pages

Normalization of database tables

Reference no: EM13859378

Reference no: EM13859378

Questions Cloud

Reviews

Write a Review

C/C++ Programming Questions & Answers

Create program that uses functions and reference parameters

Write a program using vectors and iterators

Write the code required to analyse and display the data

Write a webservices application

Iimplement a client-server of the game

Model-view-controller

Design a nested program

Convert celsius temperatures to fahrenheit temperatures

Evaluate and output the value in the given base

Design a base class shape with virtual functions

Implementation of classes

Technical paper: memory management

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT