Scribd
Upload
59 views3 pages

Data Dictionary Overview

This document contains data dictionary information for a proposed locker system including field names, data types, widths, and descriptions for three tables: locker, user, and register. The locker table contains locker and ID numbers. The user table includes user details like name, password, and rank. The register table stores user details like name, address, birthdate, gender, and ID number. The document also includes requirements models showing the input, process, output, performance, and controls for user information and reports functionality.

Uploaded by

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

Data Dictionary Overview

This document contains data dictionary information for a proposed locker system including field names, data types, widths, and descriptions for three tables: locker, user, and register. The locker table contains locker and ID numbers. The user table includes user details like name, password, and rank. The register table stores user details like name, address, birthdate, gender, and ID number. The document also includes requirements models showing the input, process, output, performance, and controls for user information and reports functionality.

Uploaded by

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

Data Dictionary

This contains information about the data of the proposed system like descriptions,

fieldnames, data types and sizes of data.

FIELD NAME DATA TYPE WIDTH DESCRIPTION

locker_number int 11 Identifies the locker number

id_number int 11 Identifies the ID number

Figure : Locker

FIELD NAME DATA TYPE WIDTH DESCRIPTION

ID number identification foreign key from the


id_number int 11
tbl_locker and tblregister

fullname varchar 50 Identifies the full name

user_name varchar 50 Identifies the user’s name

password varchar 50 Identifies user password

user_rank varchar 50 Identifies user rank

Figure : User
FIELD NAME DATA TYPE WIDTH DESCRIPTION

ID number identification foreign key from the


id_number int 11
tbl_locker and tblregister

firstname varchar 100 Identifies the first name

lastname varchar 100 Identifies the last name

middlename varchar 100 Identifies the middle name

civilstatus varchar 100 Identifies the civil status

citizenship varchar 100 Identifies the citizenship

address varchar 100 Identifies the address

mnumber varchar 100 Identifies the mobile number

email varchar 100 Identifies the email address

DoBmonth varchar 100 Identifies the month of user’s birthday

DoBday int 11 Identifies the day of user’s birthday

DoByear int 11 Identifies the year of user’s birthday

gender varchar 100 Identifies the gender of the user’s

Figure : Register

Display Admin Infromation


Output
No errors
Performance
None
Control

Figure : Requirements Modeling of User’s Information

Input
id_number, fullname , user_name, password, and user_rank
Process
Login, Add, Edit, Update
Output
Display User’s Information
Performance
NO error
Controls
None

Figure : Requirements Modeling of Reports

Input
None
Process
Display
Output
None
Performance
NO error
Controls
None

You might also like