CSCI235 - Database Systems & Design With Description of a Database Domain And Schema - IT Assignment Help

Assignment Task

Tasks
Step 1 
Improving a database design
This task requires access to either csora Oracle 19c database server, or one of datapc.. Oracle 19c database servers, or Oracle 19c running on a virtual machine.Consider a conceptual schema given below. The schema describes a domain of a sampledatabase where a number of football teams participate in a competition. Each team isidentified by its name. The teams are located at the cities. Name of a city uniquely identifieseach city. The teams play games in round-robin system, i.e. each team plays two gameswith all other teams. One game is played at home and one game is played away. A momentin time when a game starts and a venue of a game uniquely identifies each game. Thereferees enforce the rules during the games. To simplify a sample database domain, weassume that one game is referred by only one referee (like in U7 competitions). We do nothave a lot of referee and because of that we assume that a pair of attributes: first name andlast name uniquely identifies each referee. 

SQl scripts dbcreate.sql and dbdrop.sql can be downloaded from Moodle. SQLscript dbcreate.sql can be used to create the relational tables implementing a sampledatabase. SQL script dbdrop.sql can be used to drop the relational tables. The filesdbcreate.lst and dbdrop.lst contain the reports from processing of the scripts.A database designer made few mistakes at the stages of conceptual modelling and logicaldesign, i.e. during creation of conceptual schema and during transformation of conceptualschema into the relational schemas. 

Your first subtask is to remove the mistakes made by a database designer.
To do so, apply the following procedure for each relational schema.
(1) Use a short description of a database domain and information provided in a conceptualschema above and the contents of SQL script dbcreate.sql to discover nontrivialfunctional dependencies valid a relational schema.
(2) Use the functional dependencies found in the previous step to derive the minimal keysvalid in a relational schema.
(3) Find the highest normal form valid in a relational schema.
(4) If a relational schema is not in BCNF then decompose it into the smallest number ofrelational schemas in BCNF.And again, please be aware, that both original conceptual schema and the original relationalschemas may contain few mistakes.Save the nontrivial functional dependencies found, derivations of minimal keys,identifications of the normal forms and potential transformations of relational schemas ina file solution1.pdf. The file must contain all functional dependencies discovered, all erivations of minimal key and justifications for highest normal form valid in each schema.

To do so, apply the following procedure for each relational schema.
(1) Use a short description of a database domain and information provided in a conceptualschema above and the contents of SQL script dbcreate.sql to discover nontrivialfunctional dependencies valid a relational schema.
(2) Use the functional dependencies found in the previous step to derive the minimal keysvalid in a relational schema.
(3) Find the highest normal form valid in a relational schema.
(4) If a relational schema is not in BCNF then decompose it into the smallest number ofrelational schemas in BCNF.And again, please be aware, that both original conceptual schema and the original relationalschemas may contain few mistakes.Save the nontrivial functional dependencies found, derivations of minimal keys,identifications of the normal forms and potential transformations of relational schemas ina file solution1.pdf. The file must contain all functional dependencies discovered, all erivations of minimal key and justifications for highest normal form valid in each schema.

This CSCI235 - IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.