CIS017-1: Computer Systems Structure Database and Computer Networks - IT Assignment Help

Assignment Task:

Assignment 1 requires you to design and implement a relational database for the given scenario.
This is an individual assignment and each student should work independently and submit their assignment as an individual piece of work.
You should read this assignment brief very carefully, and, if it is not clear what you are asked to do, you should seek clarification.
Assignment 1 is worth 30% of the total unit mark.
The following Learning Outcomes will be addressed in this assignment:

1 Demonstrate the following knowledge and understanding:
 Comprehend the underpinning technologies of data communications and computer networking while appraising the basic system structures and the principles around data modification.

2 Demonstrate the following skills and abilities:
 Utilise problem-solving skills to put together information from different sources in order to design, develop and implement a databases or computer network. In order to pass Assessment 1 you will need to:

•  Investigate a given busines-related case study / scenario
•  Determine the database requirements for the scenario
•  Apply conceptual / logical modelling techniques to create an Entity Relationship Model and a fully normalised set of tables
•  Implement and modify a database using a set of SQL commands.
•  Edit and manipulate database records based on requirements given to you
•  Successfully detect, describe and analyse the main cause of faults within data structures.
   

Case Study
Consider the following scenario:
A hotel would like to provide an online service for customers to book rooms and to check their upcoming trips. A database needs to be created to store customer data (name, address, email, telephone number) and booking information (start and end date, double or single room) as well as room information, indicating whether a room is a single or double room. Each booking must be assigned to exactly one single or double room as indicated in the booking. Customers who are not registered yet need to register (providing their address, phone number, email address and credit card information).

This CIS017-1:  IT  Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.