Database Management System
(CS403)
Assignment No. 4
Total marks = 20
Deadline Date: 24/06/2013
Please carefully read the following instructions before attempting
the assignment.
Deadline
Your assignment must be uploaded
before or on 24th June 2013.
Rules for Marking
It should be clear that your
assignment will not get any credit if:
1. The assignment is submitted
after due date
2. The assignment is copied
3. You are supposed to submit
your assignment in .doc / Docx format. Any other formats like scan images, PDF, Zip, rar, bmp etc will not be
accepted.
For any query please contact: CS403@vu.edu.pk
Objectives
The objectives of this assignment
are,
- Giving the idea of normalizing the relations
- Providing an understanding of different types of normalization
i.e. 1st,2nd and third normal form
Scenario:
The top management of the university wants to computerize the university
employee’s records for security reason. The security information system will
comprise of three sub applications.
1.
Fingerprint system (deployed
through a biometric device)
2.
Online Employee Record Management
(ERM) that will be a web based application deployed on a central server and
access able through LAN
3.
Live Activity Monitoring System
(LAMS) deployed through security camera (CCTVs) installed on various location
in university premises.
Detail of each application is
given below:
Fingerprint system:
To achieve this task the
management wants to fix an automated fingerprint identification system for
employee’s attendance. This system automatically matches fingerprints against a
database of known prints. Attendance system
uses biometrics to guarantee the accuracy in
reporting. Attendance system works by having an employee place their finger on
a small scanner upon entering and exiting the office, the attendance record is
stored in the database. This information can later be checked by the management
to track the employee’s check in, checkout times and location as well.
Online ERM:
To guarantee security, the employee’s are provided
with a web account. Employees are provided with the user name and password so that no
one can access his / her record. Using their account, employees can mark
attendance, apply for leave, apply for loan, manage his/her bank account or see
salary slip. Employee can also generate a new password by using the “Forgot
your password?” link on the login page.
Live Activity Monitoring
System (LAMS):
To better enhance the security
system, management wants to install the security cameras to monitor the
employee’s activities more closely, to keep an eye on precious assets and
properties of the university. With the help of security cameras
unauthorized and illegal activities are controlled. The security cameras
capture images and record videos. These records are stored in the
database. The management
can view all the details about their employees at any time to monitor the
productivity and job related skills of employees. Further than case use the
information to ensure that he/she might not indulge in any immoral activities.
Tasks:
In this assignment you will
focus on the task(s) given below:
1. You are
given unnormalized relations as shown below.You are required to perform
normalization (1st to 3rd Normal forms) on the given relations and write the
resultant relations as an output after each normal form.
Relations:
Relation#01:
1. EMPLOYEE:
Emp_id, Dept_ID ,emp_name, Gender , skills, emp_dob,
Joining_date, emp_desig, Dept_name, emp_salary, emp_address, Contact_no
Relation#02:
2. CAMERA
Cam_ID, Serial_no, Model, Img_id,
Img_name, image_size, video_id , file_name , video_format, video_size
You have to perform all these tasks
given above in your solution file.
Note: First perform 1st NF
(write the resultant relations) then 2nd NF (write the resultant
relations) and at the end 3rd
NF (write the resultant relations). Use all concepts you have studied so far and
techniques in order to normalize the realtion.
No comments:
Post a Comment