Database System & Design Assignment - Redberry
14 Pages1713 Words72 Views
Added on 2020-06-04
Database System & Design Assignment - Redberry
Added on 2020-06-04
ShareRelated Documents
Database System & Design
TABLE OF CONTENTSSTAGE 1.........................................................................................................................................11.1 Selection of a suitable case for database design and implementation ..................................11.2 Enhanced Entity Relation Diagram.......................................................................................1STAGE 2..........................................................................................................................................42.1 Logical database diagram......................................................................................................42.2 Tables using Oracle DBMS..................................................................................................52.3 Indexes on tables...................................................................................................................92.4 Data population...................................................................................................................10For customer..............................................................................................................................10For employee.............................................................................................................................102.5 SQL Query writing..............................................................................................................11
STAGE 11.1 Selection of a suitable case for database design and implementation Redberry is a hotel who wants to involve a new database system that can help them inmanaging the customer's data more efficiently and appropriately. The purpose of Redberry is toprovide a wide range of products and services to the customers, satisfying their basic needs andrequirements. Its target is to expand the business in different city's, making their own landmarkand hence increasing the productivity (Coronel and Morris, 2016). Although the company storesthe information and data of all the employees but does not have any system for storing theinformation of the customers. As it has been made mandatory, so the hotel has decided to involvea new database system that can help them in storing the information of all the customers. Thedatabase will help them in giving a notification if the customer of the same name and detailshave been lived there previously. Also, it is essential for maintaining safety procedures and itcomes under the rules of the government. So, the company has decided to implement a newdatabase design so that it can help them in an increased rate of productivity. 1.2 Enhanced Entity Relation DiagramAn enhanced entity relationship diagram is considered as a conceptual data model thathelps in adding various extensions to the entity relationship diagram that has been already madeand is original (Brodie and Mylopoulos, 2012). Enterprise rules are classified as rules that helpsin determining the relationship between various different entities of the organisation. It helps indetermining the degree of relationship, domains that have been attributed and the mostimportant, the membership class. As the hotel is implementing a new database that can help themin storing the information about their customer's as well is represented as following :1
2
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
ER Diagram and Normalization for Hotel Booking Management Systemlg...
|9
|833
|461
Database Design- Project Reportlg...
|16
|1938
|339
DBMS Principles and Applicationslg...
|8
|1379
|60
Database Design and Developmentlg...
|20
|2372
|2
Database Systems and Administrationlg...
|19
|2166
|120
Database Design and Implementationlg...
|10
|1020
|304