database 数据库代写 ITS62904

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.

This is a Group assignment. It will be assessed over 100 marks and is worth 30% 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 have been included and relevant information have been provided.
• –  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 to draw the ER- model.
• –  Installation on MYSQL server required for database development.
• –  Fulfilment of requirements (i.e. Number of errors, if your code does not compile).
• –  Refer to marking schema provided in page (3)
• –  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) – Zipped File name : StudentName_Student_no (Student Leader Name) Hardcopy Format

1. a)  Cover page
2. b)  Table of contents – refer to TASK detailed in page (6 onwards).
3. 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.

Note: Late submission will be capped at 60 %

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.

EMC runs a startup center based in the Subang Jaya wishes to remodel the business database to store and manage information about their new startup. The startup center takes bookings from clients for adventure filled holidays and team building events. The client to you may or may not opt for accommodation but keen with team building actives and some just opt for accommodation and other relevant services.

Based on your business, you clients are usually classified from family members, businesses, and schools. Information stored about clients includes their unique client number, the client’s name (School name, business name, etc.), and the names and mobile contact details of the persons representing the client organisation. Some schools and business clients have provided more contact details. This to ensure contact are reached precisely on time when required as also to provide on-going marketing information.

The center has a number of accommodation options which includes: a four star hotel called Snooppy Lupiz offering different types of rooms (single, Double, King suite, Luxury suite and others) ; a hostel with large dormitories for children and smaller shared rooms for supervising adults; and a small camping ground. The name and type of these options is stored, along with the total number of people they can accommodate.

Each booking has a unique booking number, the date that booking was made, and the dates of the stay. When booking is made, clients need to state how many people will be staying, and what type of accommodation is required. Type of accommodation have to be stored preciously based on accommodation types that the hotel provides. Clients’ needs to specify whether they will use the restaurant or self-catering facilities. The booking will also include any additional facilities required by the client.

The center contains a number of additional facilities for hire. These include Board meeting rooms, conference/forum halls, and computing labs with Internet access. Portable multi-media projection and presentation equipment are also available for hire. You may consider payment chargers for all the facilities being offered. Charges information is to be tabulated by the startup team as the financial information will not be a predomination information till the system rollout.

There are various outdoor pursuits’ facilities including: climbing-wall with safety equipment, paintball-wargames, canoes, swimming, basketball, football… etc. Details of these various facilities, including any hire charges, need to be stored on the database. During any booking, the client may use these facilities. The date when a facility is booked for use must be recorded.

In order to monitor and facilitate the outdoor activities an experienced is staff is assigned to team building activities. Staff may be trained to supervise more than one outdoor pursuit facility. Each member of staff has a unique staff number, and their name and contract details (full or part time) are also recorded

Business Process Change: Document Oct 2018 (V1.1.2)

1. The system should detail down the customers address and multiple contact number for emergencies and direct marketing purpose.
2. The system need to record staff information, as a requirement for the knowing which staff whom brought the sales. This information is for all the bookings that are made personally with the staff.
3. Projections – the company would require the system to be able to sales being made. You are required to ensure that all the necessary information is recorded in the table, allowing the user to compute this totals without messy procedures.
4. Final requirement – open suggestion from your team to include 2 more requirements that would be added advantage for the system. Include the requirement into Business Process Change Nov 2018 (V1.1.2).