Scribd
Upload
13 views4 pages

Prac 5

The document provides an overview of Entity Relationship Diagrams (ERDs), which illustrate the relationships between entity sets in a database using specific symbols. It also includes a database dictionary for a web application utilizing MySQL, detailing various tables such as Admin, Staff, Attendance, Leave, Branch, and Student, along with their respective fields and data types. Each table is described with field names, data types, sizes, and descriptions to clarify their purpose within the database.

Uploaded by

Jay
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views4 pages

Prac 5

The document provides an overview of Entity Relationship Diagrams (ERDs), which illustrate the relationships between entity sets in a database using specific symbols. It also includes a database dictionary for a web application utilizing MySQL, detailing various tables such as Admin, Staff, Attendance, Leave, Branch, and Student, along with their respective fields and data types. Each table is described with field names, data types, sizes, and descriptions to clarify their purpose within the database.

Uploaded by

Jay
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

200170107128

Practical : 5

Entity Relationship Diagram :

ER Diagram stands for Entity Relationship Diagram, also known as ERD is a diagram that
displays the relationship of entity sets stored in a database. In other words, ER diagrams
help to explain the logical structure of databases. ER diagrams are created based on three
basic concepts: entities, attributes and relationships. ER Diagrams contain different
symbols that use rectangles to represent entities, ovals to define attributes and diamond
shapes to represent relationships. At first look, an ER diagram looks very similar to the
flowchart. However, ER Diagram includes many specialized symbols, and its meanings
make this model unique. The purpose of ER Diagram is to represent the entity framework
infrastructure.
200170107128
200170107128

Database Dictionary :

The current web application uses MySQL Database to store, access and retrieve the data.

Following is the data dictionary that describes the required tables along with their fields.

1. Admin

Field Name Datatype Size Description


Id VARCHAR 25 Name of the Owner
User Name VARCHAR 20 User name
Password VARCHAR 20 Password

2. Staff

Field Name Datatype Size Description


S_Id VARCHAR 25 Staff id
Name VARCHAR 20 Name of Staff
Address VARCHAR 20 Address of staff
Branch VARCHAR 20 Branch

3. Attendance

Field Name Datatype Size Description


A_id VARCHAR 20 ID
Enroll_no VARCHAR 20 Enrollment number
Atttend VARCHAR 20 Attendance
Staff VARCHAR 20 Name of staff

4. Leave

Field Name Datatype Size Description


Enroll_no VARCHAR 20 Name of service
provided
L_ID VARCHAR 20 Id of service
days VARCHAR 20 Type of Service
Provided
200170107128

5.Branch

Field Name Datatype Size Description


Seat VARCHAR 20 Seat available

B_name VARCHAR 20 Name of branch


Bid VARCHAR 20 Id of branch

6. Student

Field Name Datatype Size Description


S_Id VARCHAR 25 Student_id
Name VARCHAR 20 Name of student
Address VARCHAR 20 Address of student
Branch VARCHAR 20 Branch of student
Enroll_no VARCHAR 20 Enrollment id

You might also like