Question: Anomalies are problems that can occur in poorly planned, un-normalized databases where all the data is stored in one table. Being a database designer you

Anomalies are problems that can occur in poorly planned, un-normalized databases where all the data is stored in one table. Being a database designer you have been given the task to design a database for a company. Each employee in a company has a department associated with them as well as the student group they participate in. Suppose you designed the following database. Determine which anomalies can occur after designing the following un-normalized database? How the redundancy affects the database?

Explain the answer with the possible occurrence of anomalies example and derive a solution to overcome redundancy.

Employee_ID	NAME	Department	Student_Group
11	Akbar Khan	CS	CS_Alpha
22	Tahir Ali	EL	EL_FEST
22	Tahir Ali	EL	Management hub
33	Irfan Ahmed	SE	Software Tech
33	Irfan Ahmed	SE	Software Beta

Step by Step Solution

★★★★★

3.32 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

INSERTION anomaly If an employee is hired and not assigned to any deparment and student group then department and studentgroup column will get null va... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The following are misstatements that can occur in the sales and collection cycle: 1. A customer number on a sales invoice was transposed and, as a result, charged to the wrong customer. By the time...

Alpha Ltd makes one standard article. You have been given the following information: 1. The inventor y sheets at the year-end show the following items: Raw materials: 100 tons of steel: Cost 140 per...

As chief accountant at Italin NV, you have been given the following information by the director of research: Project Luca 000 Costs to date (pure research 25%, applied research 75%) .......... 200...

1. The bias for the present will vary from one individual to another. What happens in the previous example if the student has a smaller bias for the present that can be captured by b = 0.7. 2....

Idont know what happened. When the new system was installed, the systems analysts made a clean getaway, as far as I can tell, says Marc Schnieder, waxing philosophic. Recall that he is owner of the...

What are some of the defects or problems that can occur in the molten metal region of a fusion weld?

Describe the service quality problems that can occur in VoIP. Why are these problems so difficult to solve?

Two problems that can occur in systems that al- low threads to wait are deadlock, in which one or more threads will wait forever for an event that cannot occur, and indefinite postponement, in which...

Yield management (or revenue management) can be seen in a wide variety of industries, such as airlines, hotels, car rentals, cruising, casinos, television advertising, apartment rentals, retailing...

When General Motors (GM) decided to start a bug bounty programpaying hackers to find computer bugs in the companys information systemsthey purposely tried to avoid other companies mistakes with such...

What is an ore?

Assuming the set of all basketball players in the NBL (National Basketball League) as the universal set. Is the relation is the teammate of complete? Is it transitive? a) Complete and transitive b)...

An object on the t - axis travels at a rate given by the function v ( t ) = 2 t 5 from t = 4 to t = 9 . a . How far does the object travel on the interval 4 , 9 ? b . What is the average value of the...

Selected transactions for Neve Campbell Company during its first month in business are presented below. Sept. 1 Invested $10,000 cash in the business in exchange for common stock. 5 Purchased...

Imagine that you are the vice president of manufacturing for a Fortune 1000 manufacturing company. Describe the features and capabilities of your ideal ESS.

An accounting firm that specializes in auditing mining companies collected the data found in the file Dat9-6.xls on your data disk describing the long-term assets and long-term debt of its 12...

Airline pricing, considerations other than cost in pricing. Air Eagle is about to introduce a daily round-trip flight from New York to Los Angeles and is determining how it should price its...

The Long-Term Debt section of Rodman Company's balance sheet as of December 31, 2012, included 8% bonds payable of $600,000 less unamortized discount of $44,000. Further examination revealed that...

Suppose a chemical company is testing a plant hormone that it believes will increase the growth rate of onions. Suppose you are able to view slides of onion root tips that have been treated with the...

QUESTION 1 The largest provider of relational database tools is Sun Microsystems Inc. True False QUESTION 2 Information assets are the new currency of business. True False QUESTION 3 The database...

Requested to do an integrated summary of these paper by reflecting to the local (Malaysian) Corporate Financial Scenarios. Three views on stock markets and corporate behavior: Tobin, Veblen, and Marx...

Question #1: The author gives several reasons why the blame cast on the EMH for the global financial crisis is unfounded. Which one makes the most sense to you? Why? Which argument do you disagree...

What are the implications for corporate financial managers of the EMH as articulated and defended by the author? Frame you answer around implications for issues such as capital raising, dividend...

I need help with a question regarding the attached document, Question: The author proposes several lessons about market efficiency that we can learn from the financial crisis. One is that there are...

Please help me to answer the following file ............................................................................................... INVESTMENT AND PORTFOLIO MANAGEMENT COURSE ASSESSMENT 1...