Assignment Task:
CSIT115: Data Management and Security IT Assignment Help

Tasks
Task 1

Consider a conceptual schema given below.

 

CSIT115: Data Management and Security IT Assignment Help

(1) Perform a step of logical database design and transform a conceptual schema given above into a collection of relational schemas. Use a superset method for
implementation of generalization. No report is expected from a step of logical design.

(2) Next, use the relational schemas obtained in the previous step to create SQL script solution1.sql with CREATE TABLE statements that implement the relational
schemas.

Your CREATE TABLE statements must enforce the following types of the columns in the relational tables.

(i) All columns that contain dates must be of type DATE.

(ii) All employee codes must be fixed sixe a sequence of 6 characters.

(iii) All account numbers are sequences of 12 digits.

(iv) All interest rates are fractions in a range [0,1) with 2 positions after decimal dot.

(v) All transaction amounts are real numbers (floating point number) in a range 0.00 to 99999999.99 with 2 positions after decimal dot.

(vi) The types of all other columns in the relational tables are up to you. However, the types must make sense. For example, a city name of type integer will not get a lot
of appreciation from a person evaluating your solution.

(3) When your script is ready connect to the command line interface mysql and process the script solution1.sql implemented in the previous step. Processing of the
script must create a report. The report from processing of a script solution1.sql must be saved in a file solution1.rpt. If processing of the file returns the errors then you must eliminate the errors! Processing of your script must return NO ERRORS ! A solution with errors is worth no marks !
It is recommended to create a script drop.sql that drops all relational tables created by processing of a script solution1.sql and it is recommend to process a script
drop.sql after each processing of solution1.sql. In such a way you can avoid an unpleasant syntax error messages like:

ERROR 1050 (42S01): Table '...' already exists

Please, remember that such message also counts as an error in processing of the script and that a solution with errors is worth no marks ! To create a report you must use a technique already practiced in Laboratory 1. You can also find more information about creating reports from processing of SQL scripts in Cookbook, Recipe 3.1 How to use "mysql? Command based interface to MySQL database server? Step 4 How to save the results of SQL processing in a file? Your report must contain a listing of all SQL statements processed. To achieve that, you must logon mysql client with –v (verbose) option in the following way:

mysql –u csit115 –p -v

You can find more information on how to display SQL statements while a script is processed in Cookbook, Recipe 3.1 How to use "mysql? Command based interface to
MySQL database server ? Step 3 How to process SQL script ?. A report that contains no listing of processed SQL statements scores no marks ! So, make sure that you connect to mysql client with an option -v

 


This CSIT115: IT Assignment has been solved by our IT experts at UniLearnO. 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.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Noah
  • Posted on : December 27th, 2018

Whatsapp Tap to ChatGet instant assistance