User Account

All Pages

Members of a team to receive different grades

Assignment Help Basic Computer Science
Reference no: EM131544559

Normalisation

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. Each question is worth 5 marks 

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: EM131544559

Questions Cloud

Required return exceed foley required return : By how much does Beale's required return exceed Foley's required return?
Arrays of integer whose values range : You are to provide pseudo-code algorithm to sort arrays of integer whose values range between 0 and n-1 where n is the size of the array.
Discuss the causes and impacts of substance use and abuse : Discuss the causes and impacts of substance use and abuse, eating disorders, and health among young adults today
Valuation of declining growth stock-value of stock : Maxwell Mining Company's ore reserves are being depleted, so its sales are falling. what is the value of Maxwell Mining's stock?
Members of a team to receive different grades : The final grade awarded to the student. It is possible for members of a team to receive different grades.
Explain whether websites style appeals to target audience : Explain whether the website's style appeals to the target audience. Support your responses with examples
Describe the password attacks : Consider the monoalphabetic substitution cipher created, Given the information available to you, describe the password attacks that could be carried out.
Monoalphabetic substitution cipher : Describe how the monoalphabetic substitution cipher created in Codes and Ciphers alters the plaintext. Encode the string "helloworld" using your cipher.
Describe preservation and collection of firearms evidence : Describe the preservation and collection of the firearms evidence. Describe the preservation and collection of fingerprints, footprints and tire tracks.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Compare well-known purpose for forms and report in an access

Compare and contrast the most well-known purpose(s) for forms and reports in an Access database. Identify at least two ways in which individuals could use these tools in Access in a business sense.

  Range of radio frequencies in wireless technologies

What is the range of radio frequencies in wireless technologies? What are the pros and cons of the lowest and highest frequencies? What types of devices are used and/or supported by each frequency?

  Shortcomings of protocol prompted

Question 1: The address depletion of IPv4 and other shortcomings of this protocol prompted a new version of IP known as IPv6. Explain the advantages of this new IPv6 when compared to IPv4?

  Identify all the log file names

During this module, you explored the topics of Windows forensics, including Windows logs, directories and index files from which evidence may be obtained.

  Receiver initiated distributed scheduling algorithms

Receiver initiated distributed scheduling algorithms suppose task pre-emption at the sender site.

  Draw the pipeline execution diagram for this code

Draw the pipeline execution diagram for this code, assuming full forwarding is used and the branch is determined in the EX stage. The pipeline always predicts branch taken.

  Partial inventory processing systems

You are to write a program that serves as a partial inventory processing systems for a large toy store corporation. Each day, this company has inventory shipped from producers of toy products to its main warehouse location. The warehouse staff needs ..

  Explain ratios can you calculate based on the data provided

Which meaningful ratios can you calculate based on the data provided. Is there sufficient data to determine which is the better performing graphic. If yes, which is the best performing graphic.

  Think of a security policy

Think of a security policy you may have encountered either at school or in the workplace. Why do you suppose it was set up that way? Do you think it was effective? Would you arrive at the same solution if you were a network manager?

  Savings account on every birthday

Your grandmother has been putting $1,000 into a savings account on every birthday since your first(that is, when you turned 1). The account pays an interest rate of 7%. How much money will be in the account on your 18th birthday immediately after..

  Design a file system checker for our file system

Design a file system checker for our file system. You should call it csefsck. It will have to do the following: The DeviceID is correct All times are in the past, nothing in the future Validate that the free block list is accurate this includ..

  What is its steady-state temperature

If the surface emissivity is 1.0 and the surface is not exposed to the sun, what is its steady-state temperature? If the surface is exposed to a solar flux of , and its absorptivity to solar radiation is 0.25, what is its steady-state temperature?

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