CS312 - Database Modeling and Design

Project Specifications / System Requirements

Suppose ABC organization has decided to automate process of leave management of its employees. Leaves can be of different types: Short, Half, and Full. Leaves’ description can be: Casual, Earned, Medical, and Extra-ordinary leaves. Employees will have to do registration and create their account.
In order to apply for leave, employees first have to login their account using their login credentials i.e., user name and password. After successful login, they can apply for leave using “Apply Leave” interface. They will select leave type, leave description, leave date and time. The employees will also provide reason of leave. After leave is successfully applied, leave request will be forwarded to the manager and applied leave will either be accepted or rejected. The interface will show total, availed and remaining balance of leaves. Furthermore, the interface of “Leave History” will show details of all applied leaves such as Leave Type, Leave Description, Date, Time, Reason, and Leave Status. Admin will manage employees’ accounts, leave balance, update leave status. Admin will also manage leave history of all employees.

Tasks to Perform

You have to identify following from the above given Project Specification / Requirements:

Identify User Characteristics or type of users. Identify at least Seven Functional Requirements.

Idea solution please

@zaasmi said in CS312 Assignment 2 Solution and Discussion:

In continuation of assignment 1 of CS312, by using system requirements, we identified following entities in the system under observation;

Admin / Owner
Tour Plan
Sites
Activity
Visitor
Guide

By considering these entities in your system, you must identify entity attributes and cardinality between provided entities. Note that you are not required to add any extra entity from your side that would result in deduction of marks. So, your Task is to;
TASK: [Marks = 10 + 10 = 20]
Draw ER diagram containing entities, assumed attributes and cardinalities between these entities.

3cbd2d00-8d98-4fc8-9190-93dd10b22944-image.png

@moaaz said in CS312 Assignment 1 Solution and Discussion:

2 - Functional Requirements (at least 5) [10 Marks]

Solution:
Task 2: Functional Requirements

Admin / Owner login
The admin or owner will login himself by using associated id and password. While owner would act like super Admin.

Tour guide’s registration
Only admin will be authorized to register the guide of the tour in the system. He will have to authenticate the detail of the tour guide in the system.

Traveler/customer registration and login
Traveler must register himself before booking any tour. After registration traveler would be able to login to the system and can book the desired tour plan and seats.

Tour guide’s login
After registration of guide, the guide will be login to the system with provided login details and wait for a tour to be assigned y Admin / owner.

Create and store sites with or without activities
Only admin will also create and store sites that would have activities not have activities.

Create and store tours and allot a tour guide to a tour
Admin will create and store the tour details and also allocate a guide for each tour.

Each activity must have a name, duration and number of participants in that activity.

Manage each tour seats reservations
Admin has the responsibility to make sure that seats for each tour are properly filled. More than available seats for each tour can’t be booked.

Travelers can view the plans for each tour
Travelers or customer will be able to view the plans for each tour. They will be able to view the complete detail of each tour.

Payments methods
Payments for tour will be done online using Credit / Debit card.

Visitor / traveler is not allowed by system to book two different tours which start, or end dates are overlapped.

Visitor / traveler may apply for cancelation of tour plan to request system admin
Traveler would have the opportunity to cancel the booking request for the tour. For this purpose, visitors are required to request admin for the cancelation if the cancelation requirements meet i.e. cancel tour at least one week before its start date. Otherwise he will not be able to cancel the request and claim amount would not be refunded.

Admin would only allow to cancel that tour reservation that must be applied before one week of tour’s start date.

Admin / Owner
Admin is not authorized to supersede Owner’s decision / edit or delete or even update owner’s tour. While Owner can edit / change / delete admin’s entered information.

please share idea

Answers to Questions:

Answer no. 1:
User Characteristics or type of users [5 Marks] Admin Student Teacher Cleric Verifier (External User) Answer no. 2:
Functional Requirements (at least 5) [10 Marks] User and Admin registration. User management through System Admin (Admin can only approve the joining requests of users). Student and Teacher Data Entry. Semester Information interface to insert relevant Data. Course Information interface to insert relevant Data. Grades Information interface to insert relevant Data. Fee Collection Interface Certificate Generation through system. Certificate Verification Interface