Implement improvements to the database

Assignment Help Database Management System

Reference no: EM132362352

The Problem

Dr. Frere's research group has a huge database written and maintained in Microsoft Access that they wish to port to MySQL. Their database has thousands of records that cover information about the eastern water dragons such as description, morphology and when they were contacted. Their database has also a series of views to facilitate complex queries by the numerous researchers that work within Dr. Frere's research group.

Unfortunately, their database has only 2 tables. You will be given 2 excel spreadsheets representing those tables and a subset of their data, and a data dictionary for the table fields. Your main task is to look at the spreadsheets and propose, justify and implement improvements to the database to make it more efficient.

Your assignment is in two parts: Part A: Report, Part B: Code. You are required to submit three files:

<student_Number>_<student_first_name_last_name>_ICT320_PartA.docx qly

<student_Number>_<student_first_name_last_name>_ICT320_PartB.s

<student_Number>_<student_first_name_last_name>_ICT320_PartB.p

You are not to contact Dr. Frere's research group directly as this takes valuable resources away from field group. All client communication is to be directed through your lecturer/tutor or via the course coordinator Mr. Adriano da Silva Marinho.

Please note that all data is copyright and owned by Dr. Celine Frere's research group and or USC and is used with their permission for the purposes of this assignment. Further distribution of this data is not permitted.

For the data dictionary, please refer to the documents "User table and field descriptions.xlsx" and "Behavioural Surveys 2018.docx".

Attachment:- Database Programming.rar

Reference no: EM132362352

Questions Cloud

Technology has potential to both solve global social problem : As addressed in the readings, technology has the potential to both solve global social problems and make them worse.

Discussion on the nonprogrammed decisions : Pick one of following terms for your research: bounded rationality perspective, cognitive biases, decision learning, devil's advocate, groupthink, increment.

Creating a cloud risk management plan : For this week's assignment, you will be creating a cloud risk management plan. Please do not submit a paper; please submit a plan.

The symptoms or primary diagnostic criteria associated : Identify the symptoms or primary diagnostic criteria associated with the disorder. Describe evidence-based treatment for this disorder.

Implement improvements to the database : ICT320 - Database Programming - Your main task is to look at the spreadsheets and propose, justify and implement improvements to the database to make it more

Write on any topic related to technology security : Write on any topic related to technology security of minimum 10 pages. You must use a minimum of 5 references, citing the references in APA format where you.

How reimbursement systems benefit patient care : You have been placed on committee in your health care organization. Describe how these revenue or reimbursement systems benefit patient care or business systems

Human services profession to the delivery of human : Analyze and apply the appropriate ethical standards and social responsibilities of the human services profession to the delivery of human or community services

What is the maximum admissible RF noise figure : Consider a wireless LAN system with the following system specifications: fc = 5 GHz B = 20 MHz. What is the maximum admissible RF noise figure

Reviews

len2362352

8/28/2019 2:31:43 AM

Submission The completed assignment is to be submitted to Blackboard by the due date of The assignment will be assessed according to the marking rubric. Late submission will be penalized according to the policy in the course outline. Please note Saturday and Sunday are included in the count of days late.

len2362352

8/28/2019 2:30:55 AM

Submit your assignment to the link under Assessment->Task 2 on Blackboard. The submission link will be open a week before the due date. Please follow the submission instructions provided. The assignment will be marked out of a total of 100 marks and forms 30% of the total assessment for the course. ALL assignments will be checked for plagiarism by SafeAssign system provided by Blackboard automatically. THIS IS AN INDIVIDUAL ASSIGNMENT; COLLABORATION AND DISCUSSION WITH PEERS IS NOT PERMITTED. Refer to your Course Outline or the Course Web Site for a copy of the “Student Misconduct, Plagiarism and Collusion” guidelines. Assignment submission extensions will only be made using the official Faculty of Arts, Business & Law, University of the Sunshine Coast Guidelines. Requests for an extension to an assignment MUST be made to the course coordinator prior to the date of submission and requests made on the day of submission or after the submission date will only be considered in exceptional circumstances.

Write a Review

Required(*) Message

Database Management System Questions & Answers

Describe the relationships depicted in the given erd

Describe the relationships (identify the business rules) depicted in the Crow's Foot ERD shown in Figure.

Create a dtd file and an xsd file that specify the schemas

Create an XML file that describes 3 product elements; each product has three sub-elements: id, name, and description.

How do i display and parse a date

1) How do I display and parse a date? 2) What is object serialization? 3) Can I persist my objects using serialization instead of using a relational or object database?

Explain steps of process in increasing cardinalities

When increasing cardinalities from 1:N to N:M, which of the given steps are included in process the order of steps listed below is not relevant, only steps themselves?

Explain relational database design and implementation

ISYS 224 Database Systems - Relational Database Design & Implementation

Analyse and interpret the data

As a research officer you have been asked to summarise, analyse and interpret the data. Exam results are the focus (column A) and you will therefore need to consider the distribution of the exam results, as well as potential factors that may contr..

Fundamentals of data transmission

Radio and Microwave transmission, Satellite Communication. Introduction to Data communication: Fundamentals of data transmission, Channel speed and bit rates, Bandwidth, digital and analog signals, Asynchronous and Synchronous Transmission, Modula..

Manage change in a computer-aided design database

Margaret A. Ellis and Bjarne Stroustrup. The Annotated C++ Reference Manual. Read-ing, Mass.: Addison-Wesley (1990).

Verify the values inserted by using a query

Write INSERT statements for adding the following data to the new table: Verify the values inserted by using a query. Display each distinct agency (each agency only once)

Conventions in database modeling

In 300-500 words, describe how important are naming conventions in database modeling? What comes first: the need for a report or the data?

Developing a use case diagram

Developing activity diagrams. (Please note that for the use case, "Buy Items", there are two scenarios, namely, "General public customer buys items" and "Contractor customer buys items". You should develop an activity diagram for each of the..

Create a database and import the text files into tables

Assignment - Database Management System, MrsAda Lovelace, your manager, has set up the following tasks for you to complete for this phase of the project: Create a Database and import the four (4) Text files into four (4) Tables and Modify Table Desig..

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages