$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

FIT9132 Introduction To Databases

tag 0 Download1 Pages / 174 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

You have been supplied with a schema file FIT9132_2018S1_A2_Schema_Start.sql (which must not be altered in any way) which partially implements the Run Monash model. You have also been supplied with a document Solutions.sql - you should rename this script by prepending your authcate username to the start of the filename, e.g., Solutions.sql. This script file will be referred to as your solutions script. Within this script there are marked points where each of your solutions must be added. All of the work for assignment 2 will take place in this document so please take great care to keep regular backups, including off your computer, e.g., on Google Drive, so you do not lose work. It is suggested that you place regular backups of this file on to your FIT9132 Google shared folder. Before starting work on the task complete the header by adding your name etc., in the solutions script. Page 3 of 5 In completing this assignment you are not permitted to manually look up a value in the database, obtain its primary key or highest or lowest value in a column (for example) and use that in your answer.
 
As an example you should not look in the database and see that '42.2 Km Marathon' is event type 42K and use this in your work. You MUST USE ONLY the values listed for the particular task you are working on in this document. TASK 1: Data Definition [15 + 5 = 20 mks] For this task you are required to complete the following: 1.1 Add to your solutions script, the CREATE TABLE and CONSTRAINT definitions which are missing from the FIT9132_2018S1_A2_Schema_Start.sql script. You MUST use the relation and attribute names shown in the data model above to name tables and attributes which you add. 1.
 
2 Add the full set of DROP TABLE statements to your solutions script. In completing this section you must not use the CASCADE CONSTRAINTS clause as part of your DROP TABLE statement. Before proceeding with Task 2, you must run the file FIT9132_2018S1_A2_Schema_Start.sql (which must not be altered in any way) followed by the extra definitions that you added in 1.1 above. In a script you can run a section of the script by highlighting the lines you wish to run and selecting the run button. If at any stage your tables are corrupted during working on this assignment you simply need to run your drop commands from 1.
 
2 above and then rerun FIT9132_2018S1_A2_Schema_Start.sql and your extra definitions that you added in 1.1 above. TASK 2: [10 + 1 + 1 = 12 mks] Run the script FIT9132_2018S1_A2_Insert_Start.sql to add some initial data into the tables you created in task 1. For this task you are required to complete the following sub-tasks in the same order they have mentioned: 2.1 Add entries for the Rose family into the races for the carnival to be held at Caulfield campus in Autumn season of 2018.
 
Some of the data for the Rose family is provided to you in the table shown below. Name DOB Contact Information Race(s) Father Fernando Rose 10/10/1970 6112345678  21.1 Km Half Marathon Mother Adrianna Rose 11/11/1971 6187654321  21.1 Km Half Marathon Daughter Annamaria Rose 12/12/2004 3 Km Community Run/Walk Son Juan Rose 01/01/2006 3 Km Community Run/Walk At this stage, the Rose family is not supporting any charity and also not forming a team. For competitor numbers, you may wish to assign primary keys that you choose, provided the numbers are between 1000 and 1009. For entry numbers you may assume these are the first entries in this carnival and use the entry numbers from 1 to 4. Also, for these entries, emergency contacts and guardians should be selected from within this family.
 
2.2 An Oracle sequence is to be implemented in the database for the subsequent insertion of records into the database for COMPETITOR table. Provide the CREATE SEQUENCE statement for COMPETITOR table. The sequence will be used to generate new primary key values when adding new tuples/rows to the database. The sequence should start at 1010 and increment by 1. 2.3 Provide the DROP SEQUENCE statement for the sequence objects you have created in question 2.2 above. Page 4 of 5 TASK 3: [10 + 10 + 10 + 10 = 40 mks] Sequence created in task 2 must be used to insert data into the database for the task 3 questions. For these questions you may only use the data supplied in this task. You may assume that a phone number and name identifies a particular competitor. For this task you are required to complete the following sub-tasks in the same order they have mentioned: 3.1 Add an entry for the following competitors, who are friends and studying at Monash University, into the races to be held at Caulfield campus in Autumn season of 2018.
 
Some of the data for these competitors is provided to you in the table shown below. Both of them have nominated their friend Forrest Gump with the phone number 6142800800 to be their emergency contact person. Name DOB Contact Information Races(s) Wendy Wang 14/09/1985 6112349876 42.2 Km Marathon Sam O'Hare 08/08/1986 6198761234 42.2 Km Marathon 3.2 Sometime after the registration, Wendy has decided to form a team for 42.2 Km marathon event and call the team Gentle Earth. She will be the leader of this newly created team. Wendy would also like her team to support Cancer Council Of Victoria charity. Add this information into the database. 3.3 Sometime after Wendy setup the Gentle Earth team and the team is registered with Run Monash, Sam O'Hare decides to join the Gentle Earth team for 42.2 Km marathon event. 3
 
.4 Suppose today is 6th of May 2018 and Wendy and Sam have already completed their race and they were the only courageous ones to run the marathon for cancer research on a wet day. Update the database to record these completions. You can use your imagination for the attribute values of the rows you need to update. However, you need to ensure that the data is meaningful to the case study. TASK 4: [8 + 20 = 28 mks] For this task you are required to complete the following sub-tasks. After using the system for some time, Run Monash has realised that it is necessary to 4.1 record whether all competitors have any medical issues.
 
They do not want to keep the details of the medical condition. They only want to flag whether a competitor has a medical issue or not (the value cannot be left empty). Change the "live" database and add this required information for all competitors currently in the database. You may assume that all existing competitors will be recorded as NOT having a medical condition. The information will be updated later when the competitors reply to their request for this additional information. Sometime after sending the request to all the existing competitors for this additional information, Wendy Wang of phone number 6112349876 has contacted Run Monash and indicated that she has a medical condition.
 
Update the database to reflect this new information. You may assume that a phone number and name identifies a particular competitor. 4.2 record the type of track (Grass or Synthetic), total number of parking spaces and the type of toilets available at each location (Portable, Fixed or Mixed) since they are receiving a lot of calls for this information from participants. Change the "live" database and add this information into the database in a manner that changes made are most appropriate and consistent and data is reasonable and correct to help Run Monash retrieve this information effectively from the database.
 
Page 5 of 5 This extra data for the currently recorded addresses in the CARNIVAL table is: Current Address Track Type Toilets Parking Space 900 Dandenong Rd, Caulfield, VIC, 3145 Grass Portable 200 Scenic Blvd, Clayton, VIC, 3800 Synthetic Mixed 400 SUBMISSION REQUIREMENTS Due Date: Wed 16-MAY-2018 5 PM (Week 11) For this assignment there is only one file to submit. You are required to submit your solutions script file to Moodle before the assignment due date/time. If you need to make any comments your marker/tutor should be aware of please place them at the head of your solutions script in the "Comments for your marker:" section. Late submission will incur penalties as outlined in the unit guide.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Introduction To Databases. Retrieved from https://myassignmenthelp.com/free-samples/fit9132-introduction-to-databases/value-in-the-database.html.

My Assignment Help (2020) Introduction To Databases [Online]. Available from: https://myassignmenthelp.com/free-samples/fit9132-introduction-to-databases/value-in-the-database.html
[Accessed 02 August 2021].

My Assignment Help. 'Introduction To Databases' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/fit9132-introduction-to-databases/value-in-the-database.html> accessed 02 August 2021.

My Assignment Help. Introduction To Databases [Internet]. My Assignment Help. 2020 [cited 02 August 2021]. Available from: https://myassignmenthelp.com/free-samples/fit9132-introduction-to-databases/value-in-the-database.html.


MyAssignmenthelp.com is an eminent online assignment help service provider in Aus that would assist you with well-knit samples belonging to different subject matters. Choose assignment help and stay one step ahead of the competition with quality solutions on the go. From economics assignment help examples to samples based on management; our stalwarts cover all the crucial areas. Visit our Samples section to gain access to a huge repository of samples for free on any subject under the sun.

Latest Database Samples

ECBS5091 Ethics Of Big Data

Download : 0 | Pages : 4

Answers: Answer to Question 1: The development in technologies of Big Data has passed the limits of understanding by individual actions and their effects in the digital world. However, there are many ethical challenges faced from big data. The network of information accessed by big data forms a digital image of the information that is being accessed. This is termed as datafication in terms of technologies. This however makes it very inefficie...

Read More arrow Tags: Australia Dallas Law Patient Protection and Affordable Care Act University of Dallas 

ICT704 Non Relational Database Systems

Download : 0 | Pages : 5

Answer: Comic Crusaders are one of the largest comic books retailer having presence in United States (US) and United Kingdom (UK) who wish to have online presence in the current market. For each book they wish to store the customer’s feedback. Only those customers can provide the feedback who register their name with Comic Crusaders. MongoDB database is being used to store the details like comics, publishers and reviews & ratings.&nb...

Read More arrow

INFO6001 Database Management 1

Download : 0 | Pages : 4

Answer: Part A A brief discussion on the solution and the in modelling the problem and any issues encountered The modelling process began with indentifying the entities and their attributes. An entity was either classified as regular or weak entity. An attribute on the other hand was either grouped as key attribute, simple attribute, composite attribute, single valued attributes, multi-valued attributes, stored attribute or a derived at...

Read More arrow

BCO6185 Mobile And Executive Computing

Download : 0 | Pages : 2

Answer: The application will provide users with the ability to view recipes of different recipes for types of children’s food. The application will enable users to add their own recipes that they recommend to other users. The application will enable new users to register for them to use the app and a login feature for existing users to use to login to their accounts. The application will enable the administrator to view all the users using...

Read More arrow

INM305 Information Retrieval

Download : 0 | Pages : 15

Answer: Introduction The work is based on the facets which is the web application framework to handle the MVC architecture for the server side. It is able to handle the model for the client as well. The structure of the facet is based on allowing the navigation with the control of the web applications as well. (Anagnostopoulos  et l., 2016). It will help in providing the client side that will be for the development of the rich web a...

Read More arrow Tags: Australia New South Wales Management Accounting theory and accountability University of New South Wales Humanities 
Next

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?