Design and run queries on the database using demo

Assignment Help Database Management System

Reference no: EM133538626 , Length: word count:1500

Database Systems

Scenario

You have recently been appointed as database designer for EasyTravel Group in London. EasyTravel Group is one of UK's largest travel platforms. EasyTravel leverages their platform and technology capabilities across an extensive portfolio of businesses and brands to orchestrate the movement of people and the delivery of travel experiences on a both local and global scale.

EasyTravel Group's portfolio ticks off everything from beach holidays and city breaks through to lakes and mountains getaways with over 15,000 combinations to choose from. Plus, EasyTravel's flexible flight options, taxi transfers and flights from local airport mean a traveller can design his/her perfect holiday.

You have joined to the new fleet of database designers to manage EasyTravel Group's growing portfolio.

Task 1 - Written Report

You line manager Laura Buckingham wants to have a clear understanding of your knowledge of database management systems and you need to explain to her the database management systems that you want to utilise for their new brands. You have agreed a date for a meeting and you wish to leave him with a written report covering various aspects of database management systems which includes:

Instructions

a) A description the concept of normalisation in the storage of data.
b) An explanation of different 'Normal forms'.
c) An explanation of data and functional dependencies.
d) A comparison of the ‘hierarchical' and the 'relational' database management system.
e) An explanation of the use of entity relationship diagrams.

Task 2 - Lab demonstration

You line manager Laura was happy with your report and decided to give you a task to produce a demo relational database for their new project, EasyTravel Media Solutions where they build innovative digital marketing solutions to engage travellers on their global networks of trusted travel brands. You have to produce a database solution for them to manage huge volume of customer data.

Instructions

a. Using a suitable software, produce a comprehensive design using E-R Modelling for a fully functional system.
b. Using a suitable software, design a ‘Relational Database System' using appropriate design tools and techniques.
c. Design and run queries on the database using demo data provided by the lab instructor.
d. Integrate system security and constraints for a database system.

Task 3

Lab demonstration and Lab report

You have successfully created a database system. Now you are called in for a demonstration. In this stage, you will test the database systems live and produce required documentation as asked by the panel.

Instructions

a. Test the system against user and system requirements.
b. Use query tools to produce business reports. A range of query requests will be provided by the lab instructor such as finding sales information, revenue information or total number of users etc.
c. Produce technical and user documentation for a system.
d. Recommend improvements that may be required to ensure the continued effectiveness of the database system.

Reference no: EM133538626

Questions Cloud

Produce a comprehensive design of a network : Produce a comprehensive design of a network and providing an evaluation of typical network protocols and standards and also an evaluation of different network

Explain what the jenesys programme is : Explain what the JENESYS programme is and how does participating in such a programme help strengthen relations between Japan and the Pacific Island countries.

Why is this research theoretically interesting : Construct a short rationale (including some literature review) for an academic audience. Whyis this research theoretically interesting? What are the basic

Write the condensed structural formula of a simple molecule : Write the condensed structural formula of a simple molecule with an ether, aldehyde, ketone, ester, or alcohol functional group for your peers to name.

Design and run queries on the database using demo : Design and run queries on the database using demo data provided by the lab instructor - Integrate system security and constraints for a database system

Would you reject or accept the current diagnosis : Would you reject/accept the current diagnosis? Identify three possible conditions that may be considered as a differential diagnosis for this patient.

Describe a face to face interaction with parent and case : Example of a case note to describe a face to face interaction with parent and case manager inside the home. Describe appearances weather at home or in person.

What interactive tools might you recommend students use : What interactive tools might you recommend students use for extracurricular activities in the classroom when it comes to technology? Explain Why.

What is one environmental issue that might be associated : which one do you think would be most effective at dealing with the environmental issue you identified in Part 1, and why? In addition, share a creative solution

User Account

All Pages