create an Entity Relationship Diagram using the following Entities and their respective attritubes for an online programming competition registration for both leaners and university students.
create an Entity Relationship Diagram using the following Entities and their respective attritubes for an online
1. Host it's attributes (host Id, hostFirstName,hostLastName, hostTelNum,hostEmail,hostPassword)
2. Student(StudentId, StudentfirstName, Student Email, StudentPassword, InstitutionName)
3. Learners(leaner Id, leanerFirstName, leanerLastName, leanerPassword, SchoolName)
4. Competition(compId, comName, compDate,comTime, compRules, compRequirements)
5. Qualified Student/Leaner (id, firstName, compId,email)
Entity
An entity can be a real-world object, either animate or inanimate, that can be merely identifiable. An entity is denoted as a rectangle in an ER diagram. For example, in a school database, students, teachers, classes, and courses offered can be treated as entities. All these entities have some attributes or properties that give them their identity.
Attributes
Entities are denoted utilizing their properties, known as attributes. All attributes have values. For example, a student entity may have name, class, and age as attributes.
There exists a domain or range of values that can be assigned to attributes. For example, a student's name cannot be a numeric value. It has to be alphabetic. A student's age cannot be negative, etc.
Step by step
Solved in 2 steps with 1 images
