Table of Contents INTRODUCTION...........................................................................................................................3 PART A...........................................................................................................................................3 a) Construct the Entity relationship diagram as per the requirement of database system...........3 b) Create a relational database in the fully normalised form and also determine the primary key, foreign key...........................................................................................................................6 PART B...........................................................................................................................................7 Develop the database in MYSQL using PhpMyadmin................................................................7 CONCLUSION................................................................................................................................8
INTRODUCTION A database management is a type of software that help for creating, managing the entire data in the form of database. It provides the users and programmer with systematic ways to create, update, manage and retrieve data in proper manner. It makes possible for end users to create data and collect in the system in systematic ways. This report will discuss about the North coast Dragon Boat association because they will design an effective database that help to store and collect the data of membership, race, boat, coach and regatta in the appropriate manner. Furthermore, it will design and produce the entity relationship diagram or mention all the entities, attributes etc. This report will use the MYSQL using the PhPMyadmin should create the database system. PART A a) Construct the Entity relationship diagram as per the requirement of database system. Entity relationship diagram is represented as the model when interrelated things of interest on the specific knowledge about the domain. It is composed of entity type and also specific the relationship in the form of ER diagram. We can say that it is a another data modelling technique Illustration1: ER Diagram
that represented in graphically information system. It can be determined the conceptual and model of data that create the entity framework of overall infrastructure. Data dictionary: EntitiesAttributes Club membershipMembership id (PK) name address contact no position status ClubClub id (PK) name membership id (FK) boat id (FK) coach no (FK) RegattaRegatta no (PK) name date place club id (FK) RaceRace no (PK) Race name starting time date Heat year Regatta no (FK) CoachCoach no (PK) coach name qualification
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
date of training contact no membership id (FK) WinnerWinner id (PK) Name Time club id (FK) Regatta no (FK) Race no (FK) BoatBoat no (PK) Name Length race no (PK) Table : 1 This table is described the entities and attributes in the database tables. It has created a specific relationship between the one or more column.
b) Create a relational database in the fully normalised form and also determine the primary key, foreign key. Primary Key: It is a type of unique key for containing each records in the database table. A relational database must be consists of one primary key that create a specific relationship with another table. It depends on the preferences of administrator which possible to change the key into the database according to need and requirement. Foreign Key :It is a field in one table that uniquely determine a row of another database table. A foreign key is a group of column in relational database that provide the specific link between two tables. The data must be added one or more tables to create relational between them. For Example- In club membership table: In this table, membership id is a primary key in the club membership table which create a specific relationship with another table as a foreign key. In club table: In this table, club id is a primary key that contain unique values and not allowed the repeated values in it. On the other hand, club id is a representing as foreign key in regatta table which has established the relationship between two tables. In Race table: In this table, race no is a primary key but it has created a relationship with another winner table. Therefore, it has created a relationship between two tables. It is the representing as a foreign key to winner table. In Coach table: In this table, Coach no is a primary key because it has recoded the unique values and cannot be repeated. It is representing as a foreign key into club table and also create a relationship between them.
Insert command
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
SQL Queries: Structural query language is standards that has been used to create, retrieve and maintain the relational database system. It is particular apply to work with the structure data and information. It is associated the relationship within the data itself. In database system, it can be used the SQL statements that can use to generate the queries form the client side while it allows the user to execute the wide range of data manipulation process. It is the important language that control overall performance of database server to edit or store the data in effective ways.
(i) (iv)
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
CONCLUSION As per discussion, it concluded thatA database management is a software that can use for creating and managing data in the form of tables. It provides the users and programmer with systematic ways to create, update, manage and retrieve data in proper manner. It makes possible for end users to create data and collect in the system in systematic ways. This report is based on the case scenario of Dragon boat association which provide the better quality of services to their members. In this way, it has decided to develop the database system to contain the information in proper manner. Furthermore, this association is used the MySQL and PhPMyadmin to create a dynamic database system.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.