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

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