WORK TOGETHER WITH MIRACLESKILLS'S TUTOR TO ACHIEVE SUCCESS IN H/617/2275 DATABASE SYSTEMS - OTHM LEVEL 5 DIPLOMA IN INFORMATION TECHNOLOGY ASSIGNMENT!
Qualification - OTHM Level 5 Diploma in Information Technology
Unit Name - Database Systems
Unit code - H/617/2275
Unit Level - Level 5
Unit Credit - 20
Assignment Title - Database Systems
Learning Outcome 1: Understand basic concepts of database systems.
Learning Outcome 2: Be able to design and develop a fully functional relational database system to meet a business need.
Learning Outcome 3: Be able to test database systems and produce required documentation.
Aim: The aim of this unit is to provide learners with knowledge in database systems development and enable them to develop strong database design and development skills.
DONT MISS YOUR CHANCE TO EXCEL IN H/617/2275 DATABASE SYSTEMS ASSIGNMENT! HIRE TUTOR OF MIRACLESKILLS.COM FOR PERFECTLY WRITTEN OTHM LEVEL 5 DIPLOMA IN INFORMATION TECHNOLOGY ASSIGNMENT SOLUTIONS!
Case 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.
Assessment Task 1
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.
Assessment Task 2
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.
GET ASSURED A++ GRADE IN EACH H/617/2275 DATABASE SYSTEMS - OTHM LEVEL 5 DIPLOMA IN INFORMATION TECHNOLOGY ASSIGNMENT ORDER - ORDER FOR ORIGINALLY WRITTEN SOLUTIONS!
Assessment 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.
|
Learning Outcomes- The learner will:
|
Assessment Criteria- The learner can:
|
|
1. Understand basic concepts of
|
1.1
|
Describe the concept of normalisation in the storage
|
|
database systems.
|
1.2
|
of data.
Explain different 'Normal forms'.
|
|
|
1.3
|
Explain data and functional dependencies.
|
|
|
1.4
|
Compare and contrast the 'hierarchical' and the
|
|
|
|
'relational' database management system.
|
|
|
1.5
|
Explain the use of entity relationship diagrams.
|
|
2. Be able to design and
|
2.1
|
Produce a comprehensive design using E-R
|
|
develop a fully functional
|
|
Modelling for a fully functional system.
|
|
relational database system to
|
2.2
|
Design a 'Relational Database System' using
|
|
meet a business need.
|
2.3
|
appropriate design tools and techniques.
Design and run queries on the database.
|
|
|
2.4
|
Integrate system security and constraints for a
|
|
|
|
database system.
|
|
3. Be able to test database
|
3.1
|
Test the system against user and system requirements.
|
|
systems and produce
|
|
|
|
required documentation.
|
3.2
3.3
|
Use query tools to produce business reports.
Produce technical and user documentation for a system.
|
|
|
|
|
|
|
3.4
|
Recommend improvements that may be required to
|
|
|
|
ensure the continued effectiveness of the database
|
|
|
|
system.
|
MIRACLESKILLS.COM ACCEPTS INSTANT AND SHORT DEADLINES ORDER FOR H/617/2275 DATABASE SYSTEMS - OTHM LEVEL 5 DIPLOMA IN INFORMATION TECHNOLOGY ASSIGNMENT - ORDER TODAY FOR EXCELLENCE!