Database Management System Techniques PDF
Added on 2020-10-22
33 Pages738 Words88 Views
Introduction to Database system
Table of ContentsINTRODUCTION...........................................................................................................................3Part 1................................................................................................................................................3Part 2..............................................................................................................................................11Part 3..............................................................................................................................................23
INTRODUCTIONDatabase management system is technique or process for collecting all informationregarding the match. DBMS is necessary for managing the data in proper manner. This reportwill discuss about the different techniques and process to control the operations of databasesystem. This report will describe the tennis match management. There is different employee,staff and students participating. This database system will help for controlling, updating,inserting the information.Part 1Design database applicationsER Diagrams:For Example-Entity- MatchAttributes- match_idmatch_date
match_timematch_scorematch_refereEntity-PlayerAttributes-player_idplayer_nameplayer_emailplayer_contact noEntity-organizerAttributes-org_idorg_nameorg_email addressorg_contact noEntity-LeaderAttributes-Leader_idLeader_nameLeader_contact noLeader_email addressEntity-StudentAttributes-Student_idStudent_nameStudent_contact noStudent_email address
Entity-StaffAttributes-Staff_idStaff_nameStaff_contact noStaff_emailEntity-RoundAttributes-Round_idRound_typeEntity-TeamAttributes-Team_idTeam_nameEntity-WinnerAttributesTeam_idTeam_nameEntity – Entity is based on real world object and this is also representing as an important part ofdatabase system. Database using entity for representing the relationship between them.Characteristics of entity:Entity is an object for building an effective database table and their specific relationship amongthem. This is applicable in database for designing the relationship in the form of tables andcolumns.Entities can be categorised in different forms such as Minor entitiesMajor entities
For Example- According to design ER model, Leader is entity. It shows particular personcharacteristics and their attributes.Normalization: - normalization is a process which help for designing database tables andorganize data in proper format. Normalization technique is reducing the tables into differentformat. This is important technique useful for database management system. This technique isalso useful for reduce the data dependencies and reduce redundancy data.1NF(Normal Form) : Each and Every table contain single value in database tables.Each record need to be unique and specific.s.This table shows 1NF normal form because this database table contain all information ofstaff and they contain unique and single value2NF(Normal Form):Single column has primary key in tables.1 NF forms.3NF(Normal Form):This normal form doesn’t have any transitive functional dependencies.
Bothtables contain match_id, it means that could modify to shows only match, player information in3rd tables.Match_id can be shown as a functional data dependency in the database tables.
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Introduction to Database Managementlg...
|26
|604
|154
Database Design and Implementation | Normalizationlg...
|11
|1603
|21
Introduction of DBMS (Database Management System)lg...
|28
|2805
|27
Database Design for Tennis Tournament Systemlg...
|38
|4041
|355
Fan Trap. It is presentation of a relation between entilg...
|2
|243
|37
Designing a Database for VU University Table Tennis Matchlg...
|25
|2848
|406