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: StudentNo: StudentName: Team: FirstMajor: Project: BroadArea: Client: Supervisor: Grade:

The year the project is run

Unique student number

The full name of the student

A name the team chooses for themselves The first (or only) major of the student

A descriptive name of the project

The general IT area the project is in

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

Name of the staff member who supervises the team

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

1. Explain the problems with the existing design, in terms of the potential modification
2. anomalies that it might exhibit.
3. What normal form is the relation currently in? Explain your reasoning.
4. 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.
5. Explain how your new design addresses the problems you identified in (a) and preserves all the information in the original design.

SophiaPretty

(5)

Status NEW Posted 30 Nov 2017 01:11 PM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer