Database Design and Development Report - NIT5130, Semester 2

This report details the design and development of a database system, likely for a volunteer management scenario. It begins with an overview of the business rules governing the system, followed by an explanation of database normalization principles. The report includes an Entity-Relationship (ER) diagram illustrating the database structure, along with detailed data dictionaries for each table, specifying attributes, data types, and key constraints. Tables for Students, Members, Services, Jobs, Volunteers, and Roster are defined, outlining their respective attributes and relationships. The document also provides a bibliography of relevant sources used in the development of the database design. The assignment demonstrates practical application of database design principles, including normalization and ER modeling.

Running head: DATABASE DESIGN AND DEVELOPMENT
Database Design and Development
Name of the Student:
Name of the University:
Author Note

1
DATABASE DESIGN AND DEVELOPMENT
ER Diagram
Business Rules
The main business rules used for the development of the system are:
 The details of the students are to be stored in the system and they are to be identified by a
unique StudentID.
 The system should be able to enrol the students into the system and store their details in the
members table.
 The system should also store the details of the services in the system with services ID.
The system should also be able to store the details of the jobs which are used for the services
and are allocated to the volunteers who would be performing the tasks.

2
DATABASE DESIGN AND DEVELOPMENT
 The system should be able to store the details of the volunteers who would be available for
performing the tasks.
Normalization
The database which has been created is already normalized to thirds normal. For example, the
Student table has been considered in this discussion.
Student (StudentID (pk), StudentName, StudentAddress, StudentContact)
In the table StudentID is the primary key and no other duplicate value in the field would be
accepted by the system. Hence this is already in the first normal form. In addition to this, there is only
a single key in the table which is StudentID and no other attribute provides the uniqueness in the table
and hence the table in in a 2nd normal form. Also all the attributes in the table are dependent on the
StudentID and no other attribute and hence, there are no transitive dependency in the table and the
table is in Third normal form.
Data Dictionary
Student
Attribute Meaning Data Type Other
StudentID Identification number
of the student
Int Index – Yes
(No Duplicate)
StudentName Name of the Student Varchar (50)
StudentAddress Address of the student Varchar (100)
StudentContact Contact details of the
student
Int
Member
Attribute Meaning Data Type Other
MemberID Identification number Int Index – Yes

3
DATABASE DESIGN AND DEVELOPMENT
of the member (No Duplicate)
StudentID The corresponding
student identification
number.
Int
MemeberType The type of member
details is provided.
Varchar (50)
DietaryRequirement The dietary
requirements of the
members
Varchar(100)
Service
Attribute Meaning Data Type Other
ServiceID Service identification
number
Int Index – Yes
(No Duplicate)
ServiceType The type of service Varchar (50)
Description The description of the
service
Varchar(100)
Jobs
Attribute Meaning Data Type Other
JobID Identification number
of the member
Int Index – Yes
(No Duplicate)
ServiceID The corresponding
service identification
number.
Int
Status The status of the job Varchar (50)

4
DATABASE DESIGN AND DEVELOPMENT
Volunteers
Attribute Meaning Data Type Other
VolunteerID Identification number
of the volunteer
Int Index – Yes
(No Duplicate)
VolunteerName Name of the volunteer Varchar (50)
JobID Job identification
number
Int
MemberID Member identification
number
Int
Status The status of the
attendance of the
volunteer is provided
Varchar(100)
Roster
Attribute Meaning Data Type Other
RosterID Identification number
of the Roster
Int Index – Yes
(No Duplicate)
JobID Job identification
number
Int
volunteerID Volunteer
identification number
Int
Status The status of the
attendance of the
volunteer and job is
provided
Varchar(100)

5
DATABASE DESIGN AND DEVELOPMENT
Tables
Job
Member
Roster
Services

6
DATABASE DESIGN AND DEVELOPMENT
Students
Volunteer

7
DATABASE DESIGN AND DEVELOPMENT
Bibliography
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management.
Cengage Learning.
Hilles, M.M. and Naser, S.S.A., 2017. Knowledge-based Intelligent Tutoring System for Teaching
Mongo Database.
Parks, R.F. and Hall, C., 2016. Front-End and Back-End Database Design and Development:
Scholar’s Academy Case Study. Information Systems Education Journal, 14(2), p.58.
Stonebraker, M., Deng, D. and Brodie, M.L., 2017. Application-Database Co-Evolution: A New
Design and Development Paradigm. New England Database Day, pp.1-3.