User Account

All Pages

Explain the problems with the existing design

Assignment Help Business Economics
Reference no: EM131510503

The following question is based upon the PROJECTS relation below that lists details of team projects in a unit similar to ICT333 IT Project. You can assume that the data is representative. The unit runs once a year. Team names are always unique, but projects can be repeated (if the team one year didn't do a very good job, or the client needs it extending).

Year: The year the project is run

StudentNo: Unique student number

StudentName: The full name of the student

Team: A name the team chooses for themselves

FirstMajor: The first (or only) major of the student

Project: A descriptive name of the project

BroadArea: The general IT area the project is in

Client: Name of the person/organisation who is client for the project

Supervisor: Name of the staff member who supervises the team

Grade: The final grade awarded to the student. It is possible for members of a team to receive different grades.

You have been asked to design a relational database based on this design. You know that there are problems with the current design and that it will need to be modified in order to work effectively.

Answer the following questions.

a. Explain the problems with the existing design, in terms of the potential modification anomalies that it might exhibit.

b. What normal form is the relation currently in? Explain your reasoning.

c. Convert the relation to a set of relations in at least Third Normal Form (3NF). You only need to show the schema, not the data.

d. Explain how your new design addresses the problems you identified in (a) and preserves all the information in the original design.

Reference no: EM131510503

Questions Cloud

A medication history on a newly admitted patient : A nurse has just completed a medication history on a newly admitted patient. In order to complete medication reconciliation for this patient the nurse will?
List the specific standard and discuss how she violated it : Lisa is an RHIA and the Coding Supervisor at Davenport University Hospital. She was overheard by her son on the phone. She was discussing her son's step-mother.
How do you write a linear equation for given problem : How do you write a linear equation for $.50 per brownie will result in 200 brownies sold and $1.00 per brownie will result in 50 brownies sold?
The administration of an adrenergic agonist : A nurse is caring for a patient who is taking digoxin and a loop diuretic. Which of the following would be most important for the nurse to monitor?
Explain the problems with the existing design : Explain the problems with the existing design, in terms of the potential modification anomalies that it might exhibit.
How the evidence relates to your overall point : Contrive some kind of interpretive statement about a text from the week's reading and support with an explanation of relevant and strong textual evidence.
Explain purpose of international civil aviation organization : The International Air Transport Association is the trade association for the world's airlines, representing over 250 airlines. Describe the many contributions.
The nurse should instruct her to do which of the following : female patient has been taking zafirlukast for a week and is experiencing diarrhea. The nurse should instruct her to do which of the following?
List the name and country of all athletes : a. List the name and country of all athletes. b. List the event name and scheduled start time for all events held in the Aquatics Stadium.

Reviews

Write a Review

Business Economics Questions & Answers

  Construction permits are expected to be issued

Suppose that 8000 (i.e 8 units of one thousand) construction permits are expected to be issued in 2010. What would be the point estimate of Phoenix lumber Company’s sales for 2010?

  Described by the supply and demand functions

The market for a pack of 12 golf balls has been described by the following supply and demand functions: Depict this on your demand and supply diagram. (Hint: the new tax inclusive demand function will be: P = 91 – 5Q) What is the new market equilibri..

  Increase or decrease the supply of cell phones

Using the supply curve shifters (SPEND) explain whether each of the following will increase or decrease the supply of cell phones. Tell whether the supply curve shifts to the right or to the left.

  After learning short run and long run cost functions

After learning short run and long run cost functions of industries, please give examples of industries which belong to the increasing return to scale, decreasing return to scale, and constant return to scale respectively. Explain why your pick follow..

  Global per capita income-maintain current living standards

The World Bank projects that the world's population will increase from 7 billion to 8 billion in 2025. World output today is roughly $80 trillion. What is global per capita income today? What will per capita income be in 2025 if the world's economy d..

  Huge role in the advancement of protestant reformation

The printing press played a huge role in the advancement of the Protestant Reformation, changing forever the way people communicate. To deepen our understanding of this topic, can you think of any other technologies that have had a similar impact on ..

  Suppose market for good x has four-firm concentration ratio

Suppose the market for good X has a four-firm concentration ratio of 0.50. Furthermore, assume that total sales in the industry are $1.2 million. Based on this information, we know that sales for the largest four firms in the industry equal (in aggre..

  Income from an investment in renewable energy sources

The Pedernales Electric Cooperative estimates that the present worth now of income from an investment in renewable energy sources is $12,475,000. There will be no income in years 1 and 2, but in year 3 incomes will be $250,000, and thereafter it will..

  Find the utility level sssociated with the optimal bundle

Teresa likes to consume chocolate and yogurt. Her utility function is given by U(x,y) = x^0.5y^0.5 where x and y are the quantities of chocolate and yogurt she consumes. Suppose that her income is $10 and the initial prices for both of the goods is $..

  Future costs as well as future payments have present values

Future costs as well as future payments have present values. For example, some researchers say that global warming could cost $1 trillion per year in 100 years. Using the present value formula and an interest rate r = 5%, one researcher (William Nord..

  Q1 the price of a laptop increases by 20 and there is a 40

q1. the price of a laptop increases by 20 and there is a 40 drop in the quantity demanded. the price of a pack of

  The value of price elasticity of supply

If an increase in price from $1 to $2 per unit leads to an increase in quantity supplied from 20 to 100 units, then what is the value of price elasticity of supply?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd