(solved) Case Study of Database
37 Pages5685 Words315 Views
Added on 2020-10-22
(solved) Case Study of Database
Added on 2020-10-22
ShareRelated Documents
DATABASE
Table of ContentsINTRODUCTION...........................................................................................................................4TASKS.............................................................................................................................................4An Assumption that make sure that the information not being clear or detailed on the basis ofcase study.....................................................................................................................................4Business constraints, business rule choose to the business case study and common knowledgeabout the enterprise sectors..........................................................................................................5Question- 2.......................................................................................................................................5Create entity relationship diagram on the basis of given case study and also included thedifferent information in proper manner. .....................................................................................5Question- 3.......................................................................................................................................8Relational schema and database tables........................................................................................8Question- 4.....................................................................................................................................16Design the decision of successful implementation of database on one centralised locations. .16Discuss the RDBMS, file system and indexes and underlying the hardware decisions. ..........16Transaction analysis in the database tables ...............................................................................16Question- 5.....................................................................................................................................17Purpose of Queries- ...................................................................................................................17SQL Syntax and queries.............................................................................................................17Question- 6.....................................................................................................................................20Evaluate the different types of security threats in the database solution. .................................20Security measure in the database that protect the database and data.........................................21The most important threats is to be centralised in the database system. ...................................22Question- 7.....................................................................................................................................23Need and requirement of optimisation in the database system. ................................................23Question- 8.....................................................................................................................................23Motivation is needed in the alternative database solution such as NoSQL ..............................23Question- 9 ....................................................................................................................................25Personal reflection-....................................................................................................................25CONCLUSION..............................................................................................................................27
INTRODUCTIONDatabase management system is basically the collection of information and data thatgenerally store or access in the computer system. Sometimes, Database management system willhelp for developing the formal design in proper manner. This system will interact with thesoftware that connect with the user and applications to create an effective database system. Thisreport will discuss about the Olympic preparation committee management system that managethe entire task and operations effectively and efficiently. This database system should bemaintain their management process. Furthermore, it will create database system and entityrelation diagram that represented all the entities and their particular attributes in this report. Itincludes the different conditions in ER diagram such as all real world entities, sub type, primarykey, foreign key and also discuss about the description of relation between the database tables. Inanother ways, this assignment will cover the relation schema and appropriate attribute whereeach schema shows the primary and foreign key. At last, this report will create report to explainthe database by using the case study of business. TASKSQuestion- 1An Assumption that make sure that the information not being clear or detailed on the basis ofcase study.An Assumption is the thing that accept the truth on the certain condition and situation. Inthis way, it can be said that in Olympic preparation's system has some assumption. Sometimes,The information and detailed cannot be clear in appropriate manner because it can be lost andcannot manage in proper manner that's why, it is important for managing all the details in theform of database management system. According to business case study, the Olympicpreparation is managed by the committee to perform different task to manage their operationsand function in proper manner. In this system, it is useful for determine the relationship betweenthe different entities that's why, it will create an effective database system in proper manner.There are different assumptions that applicable in the Olympic preparation management system. In this Olympic, Team members are participated in the events that has to be follows andbook in the advance manner. It is the best ways to participate in the sports on the basis oftheir interest. Athletes also get the training session to improve their sports in proper manner.
Participants also part of event and take part in the global tracking initiatives that cantracking with the help of devices. Business constraints, business rule choose to the business case study and common knowledgeabout the enterprise sectors.Business constraints are anything that interfere with profitability of the company or business. Toimprove business these constraints need to be minimized or removed like time constraint,finance, management, business rules. Business rules are the type of constraint which cannot beremoved and need to be followed (Adetunji, Lamont and Schmidt, 2018). In the above Olympicpreparation case study there are few business constraints and business rules likeOnly one team at a time can train at training venue and also they need to pre-book thevenue with deposit amount.Teams can only book a venue maximum of four times not more than that.All the committee members can only take responsibility of three to six country accountsmaximum.Question- 2Create entity relationship diagram on the basis of given case study and also included the differentinformation in proper manner. Entity relationship diagram is basically the model of different entities that interrelated to eachother to specific knowledge of domain. This ER model is composed of various entity types andcreate specific relationship between the existing entity type. In the business case study, it can becreate the entity relationship diagram of Olympic preparation management system. This systemwill contain the different types of entities and contain specific attributes in appropriate manner.Entity relationship model is commonly formed to represent the business need in order to performdifferent task in the Olympic preparation management system in effective manner. There aredifferent types of entities and attributes represented in the diagram that also considered theprimary key and foreign key in the database tables. Entities: Attributes:Venuevenue_idvenue_name
Venue_typevenue_locationEventEvent_idEvent_nameEvent_timeEvent_dateJudgeJudge_idjudge_namejudge_genderjudge_numbertraining_sessiontraining_idCoach_nametraining_datetraining_timeAthleteathlete_idathlete_nameathlete_countryathlete_numberteamteam_idteam_nameteam_rankcommitteeMember_idmember_namemanagermanager_idmanager_namemange/type_servicesSponsorSponsor_nameAccording to the business model of case study, it is important for identifying the specificrole and responsibilities in the Olympic preparation committee. In ER Model, there are differententities and their specific attributes participate in the entity relationship diagram or connect toeach other for creating an effective relationship with the help of primary key and foreign key.
Entity relationship Diagram can be included all the criteria. Primary key- Primary is basically the key that create relational database where each andevery record contain the unique values. It is generally unique identified for example- athlete_id ,team_id, venue_id, event_id, manager_id etc. All the entities contain the unique value thatcannot be repeat in the data base system. In the relational database system, it is needed for oneprimary key in the table and it appears in the columns form of relational database tables. Foreign key- It is a collection of field where one or more table contain the primary keythat show the same primary key in another table as foreign key ( Atzeni, Cabibbo and Torlone,2018). According to the ER diagram, venue table contain the event id because event id isgenerally primary key in the venue table but it can show the foreign key in the venue table. Inthis way, we can say that it will create relationship between two tables. Aggregation- Sometimes, Entity relationship diagram cannot be representing therelationship between the entity that's why, it required some scenario to understand and representin the proper manner. The relationship with the different entities is aggregated to the higher levelof entity. For Example- the athletes are participated in the event but may require the venuelocation that ' why, in this way, it can be created aggregation in between the different entities. Composition- It is the more restrictive where it can be composed between the twoobjects and cannot be composed without having the objects. Generalization- It is a process of identifying the common attribute of different entities inproper manner. In this way, it easily determines that where three different entities represented inthe er model which is common attribute. For Example- in this relationship diagram, there arethree different entities such as training session, athletes and booking are interconnected with IS-A relationship because athletes can be book the training session for the purpose of increase theircapabilities and performance. All the key constraints are participated in the ER model that help for creating a relationshipbetween the different entities in the business case study in proper manner. Question- 3Relational schema and database tablesNormalization is type of database design which organizes tables in a manner that reducesredundancy and dependence of data (Cumin and et.al., 2017). In this large tables are divided into
smaller tables and link then using relationships. There are many types of normal forms but mainare;First normal form: this rule says that all the attributes in a relation must have atomicdomainsSecond normal Form: Second normal form says that each non-prime attribute should befunctionally dependent on prime attribute. Third Normal form: for third normal form it is important that tables should be in secondnormal form. Then no prime attributes should be dependent on prime key attributes.Boyce-Codd Normal Form: it is an extended version of third normal form as it says thatfor any non trivial dependency, X-> A, X must be a super key.Database tables-
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Entity Relationship Diagram for Database INTRODUCTION 3 TASKSlg...
|20
|1532
|227
Report on Data Analysis and Design- Fast Track Health Centrelg...
|23
|5165
|232
Database Analysis and Design Assignmentlg...
|30
|2171
|128
Database Design: Assumptions, Logical Design, Physical Design, Querieslg...
|29
|4696
|56
Assignment Solution for Data Warehouselg...
|20
|3019
|43
DATA & KNOWLEDGE MANAGEMENTlg...
|19
|3471
|23