Introduction to Database Management Assignment

Added on - 06 Jan 2021

  • 26

    Pages

  • 604

    Words

  • 29

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 6 of 26 pages
Introduction to database management1
ContentsINTRODUCTION...........................................................................................................................................3Part 1.......................................................................................................................................................3Part 2.....................................................................................................................................................10Part 3.....................................................................................................................................................16CONCLUSION.............................................................................................................................................262
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
Attributes-match_idmatch_datematch_timematch_scorematch_refereEntity-PlayerAttributes-player_idplayer_nameplayer_emailplayer_contact noEntity-organizerAttributes-org_idorg_nameorg_email addressorg_contact noEntity-LeaderAttributes-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
Entity-TeamAttributes-Team_idTeam_nameEntity-WinnerAttributesTeam_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 designingdatabase 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
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document