Course Choosing Database Diagram
Use immediately

Course Choosing Database 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

106
2
4
publish time: 2021-04-25
Kiraaaa

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. As per the database diagram, the data can be easily accessed, managed, modified, updated, controlled, and organized. It should be noted here that most databases use structured query languages (SQL) for writing and querying data. As the course choosing database diagram image shows, databases are designed to hold larger collections of organized information as it allows multiple users at the same time to quickly and securely access and query the data using highly complex logic and language. Use EdrawMax or EdrawMax Online to create a database diagram as the software has all the symbols and shapes that are required to create a high-functioning database.

See More Related Templates