Entity Relationship diagram
Develop a simple data model for a student data- base that includes student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete Entity Relationship diagram that shows how these tables are related to one another.
attributes for tables
|
Student_contactData |
|
Student_ID Name Address Age Gender Phone Number
|
primary key=Student_ID
|
Student_DemographicData |
|
Student_ID QualId HighestDegree NumberOfYear languagespoken
|
primary key=QualId
Foreign key=Student_ID
|
Student_GradeData |
|
Student_ID Subject Marks Grade
|
primary key=Marks
Foreign key=Student_ID
|
Student_FinancialData |
|
Student_ID Date_Of_Birth Scholarship Year Fees
|
primary key=Date_Of_Birth
Foreign key=Student_ID
Step by step
Solved in 2 steps
