logo

Introduction to Database Management

   

Added on  2020-10-22

26 Pages604 Words154 Views
Introduction to database management1
Introduction to Database Management_1
ContentsINTRODUCTION...........................................................................................................................................3Part 1.......................................................................................................................................................3Part 2.....................................................................................................................................................10Part 3.....................................................................................................................................................16CONCLUSION.............................................................................................................................................262
Introduction to Database Management_2
INTRODUCTIONDatabase management system is process for collecting the information and data ofparticular organization as well as institutes. Database is a technique to update, delete, insert andretrieve data in effective manner. It also stores information with full of security and privacy. Thisreport will describe the database of tennis match that collect all information regarding thetournament and players those who is participating in the match. Part 1Design database applicationsER Diagrams:Figure: 1ER diagram is consisting of relationship between entities and attributes. This diagram should berelationship among them. Entity relationship diagram is a graphical representation that allows todesign effective and efficient database system. According to figure: 1 , they have differententities and attributes used in database implementations.For Example-Entity- Match3
Introduction to Database Management_3
Attributes- match_idmatch_datematch_timematch_scorematch_refereEntity-PlayerAttributes-player_idplayer_nameplayer_emailplayer_contact noEntity-organizerAttributes-org_idorg_nameorg_email addressorg_contact noEntity-LeaderAttributes-4
Introduction to Database Management_4
Leader_idLeader_nameLeader_contact noLeader_email addressEntity-StudentAttributes-Student_idStudent_nameStudent_contact noStudent_email addressEntity-StaffAttributes-Staff_idStaff_nameStaff_contact noStaff_emailEntity-RoundAttributes-Round_idRound_type5
Introduction to Database Management_5
Entity-TeamAttributes-Team_idTeam_nameEntity-WinnerAttributes Team_idTeam_nameEntity – This is a real world object that performed different operations in database systemAttributes- attributes is representing the actual properties of particular entity in database system.Normalization: - normalization is a technique which help for designing database tables andorganize into proper manner. This technique is also useful for reduce the data dependencies and reduceredundancy data.1NF(Normal Form) : Each and Every table contain single value in database tables.Each record need to be unique and specific.6
Introduction to Database Management_6

End of preview

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

Related Documents
Database Management System Techniques PDF
|33
|738
|88

Database Design for Tennis Tournament System
|38
|4041
|355

Introduction of DBMS (Database Management System)
|28
|2805
|27

Database Design for Tennis Match Management System
|39
|3891
|53

Database Design and Table structure
|54
|5988
|17

Designing a Database for VU University Table Tennis Match
|25
|2848
|406