Limited-time offer! Save up to 50% Off | Solutions starting at $6 each  

Entity Relationship Model : Assignment

Added on - 23 Nov 2020

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 8 of 39 pages
Student Enrolment for Job
Table of ContentsINTRODUCTION...........................................................................................................................3TASK 1............................................................................................................................................31.1 Develop an entity relationship model...................................................................................31.2 Business case of entity relations in database system............................................................81.3 Map the Entity relationship diagram into a set of relations in at least Third Normal Form(3NF)...........................................................................................................................................8TASK 2..........................................................................................................................................14A). Implement the data dictionary to create relational database in PhpMyAdmin..................14B). Queries...............................................................................................................................19C). Design forms and reports....................................................................................................25CONCLUSION..............................................................................................................................30REFERENCES..............................................................................................................................31Appendix A....................................................................................................................................32
INTRODUCTIONDatabase management system is a type of software that helps for managing the largenumber of data in proper manner. This software will possible for create, read, delete and updatethe data in the database system. It is an essential for DBMS to serve as an interface between thedata and end users. This assignment will discuss about the database that stored all theinformation of student in proper manner. It will discover the Entity relationship diagram to showthe relationship between different entities. This report will discuss about the Normalizationforms like 1NF, 2NF, 3NF. These forms are useful in tables to create relationship between them.TASK 11.1 Develop an entity relationship modelEntity relationship diagram is a type of graphical representation that is created a relationshipbetween the different entities. An entity is an object or component of particular data whichdefines it properties (Davis, 2018). ER is a representation and conceptual model of data that usedfor representing the framework structure of entity. This Entity relationship diagram is contain theelements:EntitiesAttributesIllustration1: ER Diagram
RelationshipFor creating ER diagram that involved some specific steps:First of all, defining and identifying the entitiesDetermining all the relationship or interaction among the entitiesAnalysing the nature of interaction and identifying the cardinality of the relationshipsAt last, it is creating the Entity relationship diagram in effective ways.A).Demonstrate all necessary entitiesStudentCourseJobRoasterVolunteersFacilityThese are the different type of entities help for creating an effective relationship database systemwhere all entities are interconnected to each other.B).Demonstrate the All attributesStudent tableAttributesStudent_idNamecityphone nostatefamily nameCourse tableAttributesCourse_idnametypestudent id (PK)Roaster
AttributesDatetimefacility id (FK)VolunteersAttributesVolunteers id (PK)taskstudent id
JobAttributesJob id (PK)typepositionFacilityAttributesFacility idnametypeThese are the entities that contain specific attributes and also help for creating relationshipbetween the different tables (Hogan, 2018). There are some primary keys and foreign keys thatsupport to build relationship between them.C).Relationship between the entitiesEntitiesRelationshipStudentStudent id is created relationship with thecourse tableJobJob id is created relationship between thevolunteers because all the volunteers aremanaged the information related job.VolunteersVolunteers are also created relationshipbetween the job tables.FacilityFacility id is created a relationship between theroasters because they are planning to managethe roaster of students like timing and date.RoasterStudent relationship with the roaster to checkthe details of daily routine Job relatedinformation.CourseStudent id is created a relationship between thecourses because student easily checks thedetails of courses.
D).Demonstrate the unique identifiers and nature of interaction between entitiesA relationship is associated with the different entities that describe the interaction amongthe entities by using primary key attributes. In entity relationship, there is various number ofinstance of one entity that can trust and associated with another entity instances. It can be createdmany relationship such as one to one, one to many, many to one and many to many etc. this typeof relationship is also known as cardinality (JangLee and Ahn, 2018).Student enrolled for job database system is designed for the purpose to collect all theinformation and details in effective manner.Let us consider the real world entities such as student, volunteer, roaster, course, job andfacility. A student has attributes such as student id, name, phone, city, state. Similarly, job id andtype and position can be defined as attributes of job table. In this way, student can interact withthe many job position according to their qualifications but one job position is filled by onestudent (Mior and Salem, 2018). In this way, it is identified that this will create many to onerelationship between student or job tables.On the other hand, one student is taking admission in one course by using primary keystudent id that shows foreign key in course table. It is created a one to one relationship betweenthem. In this way, it easily demonstrates the unique identifier and represented as nature ofinteraction between the different entities.
1.2 Business case of entity relations in database system.Each student can fill only one entry form, not more than one.Each student can apply for more than one job type for more than one position.Each student can get selected in more than one job but can choose to join only one job.Volunteers can volunteer in more than one event.Faculty might assist more than one student.1.3 Map the Entity relationship diagram into a set of relations in at least Third Normal Form(3NF).Normalization:-Normalization is basically database design technique which organizes tables in propermanner and also reduces the redundancy and dependency of data. The redundancy in relationmay cause updating, insertion and deletion anomalies. It also helps for minimizing theredundancy in relations.First Normal Form-A database contains the first normal form when it satisfies the conditions such as there is norepeating group and contain atomic values in proper manner (Peffers, Tuunanen and Niehaves,2018).If the relations contain the multi values attributes and composite, it can violate the first normalform. A relation is in the first normal form when every attributes in that relations is known assingle valued attributes.Student table-Student idnamePhonecityStateFamilynameJob id1John7889932SydneyNew southwalesKim32william7839240PerthWesternAustraliajockey13Somye6567433AdelaideSouthAustralianick2
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