logo

Database Technologies Assignment 1

Develop skills in managing data in databases and gain understanding of data model development and implementation using a commercially available database management system development tool.

11 Pages1115 Words70 Views
   

Added on  2022-12-26

About This Document

This assignment covers topics such as database creation, SQL queries, functional dependencies, third normalized relations, and research questions on big data and traditional relational data.

Database Technologies Assignment 1

Develop skills in managing data in databases and gain understanding of data model development and implementation using a commercially available database management system development tool.

   Added on 2022-12-26

ShareRelated Documents
Database
Technolog
ies
May 6
201
9
Student ID:
Student Name:
Assignmen
t 1
Database Technologies Assignment 1_1
Part B
Contents
Part B........................................................................................................................... 2
1) Database Creation...................................................................................................... 3
2) SQL Queries............................................................................................................ 5
3 A) Functional Dependencies......................................................................................... 7
3 B) Third Normalized Relations...................................................................................... 8
4) Research Questions.................................................................................................... 9
Difference between Big Data and Traditional Relational Data...................................................9
Hadoop...................................................................................................................... 9References............................................................................................................... 11
Database Technologies Assignment 1_2
1) Database Creation
Hotels Table
Rooms Table
Database Technologies Assignment 1_3
Guests Table
Bookings Table
Payments Table
Database Technologies Assignment 1_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Assignment on Big data PDF
|34
|5657
|33

MN405 Managing Data in Databases
|10
|1312
|19

MN405- Data and Information Management
|10
|1298
|142

Research and SQL Queries
|10
|692
|446

Research and SQL Queries
|11
|831
|352

Moving Faculty Information System from RDBMS to Hadoop using Pig Latin Scripts
|7
|1339
|492