数据库代做、代写MySQL/HeidiSQL/TOAD、代写mysql 语句、代做sql mysql 报告

日期：2018-08-26 06:25

Assignment Objective:

1. Students will create the design model for a case study that have been given in the

assignment.

2. Students will be able to create database and tables using the right data type that is most

suitable support the data insertion to take place.

3. Students will be able to produced required reports from the database using SQL query

language.

2

Instruction

This is a Group assignment. It will be assessed over 100 marks and is worth 60% of the final

marks for this module. Marks will typically be awarded on the basis of the following broad

criteria, although other constructive factors will be taken into account:

- You are allowed to make references and records all referenced being used for

completion of the assignment.

- Case study information given below.

- You should be able to explain the references made for your answer in detail.

- Take note that the assignment has 3 sessions and all need to be answered.

- You can download and use Visual Paradigm / other open source tools to draw the ERmodel.

- Installation on MYSQL server required for database development.

- Fulfilment of requirements (i.e. No error, if your code does not compile, your mark will be

capped at 60%)

- Correctness of logic and use of appropriate sequel scripting technique.

- Correct results/output - example output database, tables, relationship and data stored.

- Scripting style:

o Adherence to MySQL/HeidiSQL/TOAD naming convention and program

readability

o Choice of attributes names and column naming has to adhere to MySQL

Documentation.

Submission:

It should be made electronically to the assignment submission section through your TIMeS

account. It is your responsibility to let me know immediately, via email, if there appears to be

any problem at all with your submission.

Documentation: 2 separate files (Word document & SQL File)

File name : StudentName_Student_no

Hardcopy Format

a) Cover page

b) Table of contents – refer to TASK detailed next page.

c) References page

 Comprises of all the above with proper formatting, all answers must follow the question

number and the labeling used in the assignment.

Academic impropriety:

Submitting the course work means you have agreed that your work is original and comply with

the rules and regulations of Academic Impropriety.

Note: Copying, cheating, attempts to cheat, plagiarism, collusion and any other attempts to gain

an unfair advantage in assessment result in awarding 0 marks to all parties concerned.

3

CASE STUDY: Dream Startup Ventures (DSV)

BEST UNIVERSITY is a medical university in Jakarta. The student enrollment in the university

is quite large; the university students are aggressively involved with only in netball and scuba

diving.

However, the athletic unit has been encouraging to develop a sports club. The university has

received a large cash endowment for the development of the sports club, the university’s board

of directors agreed to its establishment. The primary objective of the sports club is to encourage

students to participate in sports and activities that promote the national goal of imparting sports

for good health and strong bodies.

The sports club is now responsible to organize sports activities for interested students. With this

initiative the club will create schedules for each sport, assign players to teams, provide a coach

and a student leader to represent the team, and manage the team’s playing locations. The

sports club will also offer required sports equipment that registered teams and they can look

through from list equipment’s and selected the items required for practice and games.

Part of the directive assigned by the board for the sports club is to demonstrate that students

are utilizing its service at the same time participating on teams and using equipment that is

made ready for them. The sports club is responsible to provide reports each semester

indicating which sports were offered, how many students participated “in them and other

information as requested by the university board”. An Admission counselor is appointed by the

university and he will also use these reports to show prospective student available and to

demonstrate the many opportunities to participate in sports at the university.

Ms. Lynette has been appointed was the President of the Sports club. Lynette has hired you to

develop and maintain the database that will manage the clubs activities and produce the

required reports. As understood from the case study that the sports club is new, Lynette is not

yet certain of the data the club needs to collect and manage. Initially, she wants the database to

manage data about each sport that is being offered by the sports club (including team

assignments, coaches, and scheduling), the students who sign up for sports teams, and the

equipment.

Imagine that you are the only person responsible for the database; there is a lot of responsibility

on your shoulders to provide a database that works well for the department.

4

Task:

A) Design

1. Entity – Relationship Diagram (ERD) - Map the entities with appropriate relationships

2. Physical Model (Relational Model)  Provide the necessary information for Model

(Relational Model - ensure data integrity).

3. Prepare the Data Dictionary for the system that you have planned to roll out.

B) Deployment

4. Implementation – create database, tables and populate the data (each table should have

10 rows of valid records).

C) SQL Report:

i. Create a contact list that the staff can use to contact the students. You are required to

provide both the land line number and mobile number. Ensure to arrange the list of the

based on the contact number.

ii. As staff serves as coach in addition to their other responsibilities, the staff needs to

schedule their time carefully. In particular, they need to monitor people who coach more

than one sport. You are required to list coaches who are assigned to more than one

sport and to identify the sports to which each coach is assigned.

iii. Identification of missing forms - create a list, including all phone numbers, of students

who are missing one or both of the required forms. The list should also identify the

missing form.

iv. The club needs a list of coaching assignments. Provide the maximum and minimum

numbers of players on each team, and the date the teams start playing.

v. Recall that students must sign a waiver of liability and maintain academic approval

before they can play a sport. Produce a list showing students and whether they are

approved or not to play sports. If a student has submitted both the waiver and academic

approval forms, indicate that they are approved to play. If the student has not submitted

both forms, indicate that they are not approved to play. Organize the list so that those

with approval are grouped at the beginning.

5

Marks Tabulation process:

1. Student need to be aware that database design outcome effects the development

process of the database. If there design is not being properly considered then the

implementation and roll-out carriers the effect of the database design. In simple

reduction of marks with design will be carried to development as well. Incorrect

and inaccurate design leads to incorrect and inaccurate development as well,

although the implementation is complete.

6