CSIT115/CSIT815: Data Management and Security – Logical Database Design – SQL Script – IT Assessment Answer

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

CSIT115/CSIT815: Data Management and Security Assessment Answer
Task: 1
Consider a conceptual schema given below.
IT

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.

Next, use the relational schemas obtained in the previous step to create SQL script 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.

All columns that contain dates must be of type DATE.

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

All account numbers are sequences of 12 digits.

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

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

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.

Note, that you MUST use only CREATE TABLE statements and no other statement of SQL !
You  can  find  a  lot  of  information  about  implementation  of  CREATE       TABLE
statements in a presentation 09 SQL – Data Definition Language (DDL) and in Cookbook, How to use data definition and basic data manipulation statements of SQL, Recipe 4.1 How to create and how to alter the relational tables?
You can use either graphical user interface MySQL Workbench or command line interface mysql to implement your script.
No report is expected from a step (2).

When your script is ready connect to the command line interface mysql and process the script 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 !
And again, … a report from processing of SQL script must contain NO ERRORS !
This CSIT115/CSIT815: IT Assignment  has been solved by our IT experts at TVAssignmentHelp. 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.

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services