Pay
Course Choosing ER Diagram

Course Choosing ER Diagram

Teacher Log-in

Teacher No.

Log-in Time

Characters(9)

Date & Time

Log-off Time

Date & Time

Operating Record

Text

Admin

Admin No.

Admin Name

Characters(5)

Variable Characters(16)

User Name

Long Variable Characters(16)

Password

Characters

Remarks

Text

Student Log-in

Student No.

Log-in Time

Characters(5)

Date & Time

Log-off Time

Date & Time

Operating Record

Text

Teacher

Teacher No.

Teacher Name

Characters(9)

Variable Characters(16)

School No.

Variable Characters(5)

User Name

Variable Characters(16)

Password

Characters(16)

Remarks

Text

Student

Student No.

Name

Characters(11)

Variable Characters(16)

Gender

Characters(2)

Date of Birth

Date

Class No.

Characters(5)

Remarks

Text(50)

Grade

Short integer

School

School No.

School Name

Characters(5)

Variable Characters(10)

Class

Class No.

Class Name

Characters(5)

Variable Characters(2)

School No.

Variable Characters(5)

Course Choosing

Student No.

Course No.

Characters(11)

Characters(5)

Score

Short Float

Teaching Class No.

Characters(5)

Teaching Class

Teaching Class No.

Teacher No.

Characters(5)

Characters(9)

Course Code

Characters(5)

Period Time

Date & Time

Class Location

Variable Characters(16)

Number of Student

Short integer

Course

Course No.

Course Name

Characters(5)

Variable Characters(16)

School Year

Short integer

Acdemic Score

Short integer

Course Intro.

Text(50)

Total Hours

Short integer

Student Number Limit

Short integer

Log-in

Admin No.

Log-in Time

Characters(5)

Date & Time

Log-off Time

Date & Time

Operating Record

Text

11
0
1
publish time: 2021-04-25
Kiraaaa

The below ER diagram shows different entities like admin, student, course, and teaching classes along with the respective attributes. A course entity-relationship diagram (ERD) shows the relationships of entity sets stored in a database. By defining the entities, their attributes and showing the relationships between them, an ER diagram illustrates the logical structure of databases. Businesses with complex databases use ER diagrams as it helps them communicate the landscape of the business to different teams, and the course choosing ER diagrams will help understand the applications needed to support the business.

See More Related Templates

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
22
0
0
DILSHAN SACHINDRA