CS403 Assignment # 3 Best Solution - Spring 2013
Page 1 of 1 • Share
CS403 Assignment # 3 Best Solution - Spring 2013
Assalam o alikum
Dear Students
Please share your idea solution
Database Management System (CS403)
Assignment No. 3
Total marks = 20
Deadline Date: 21/05/2013
Please carefully read the following instructions before attempting the assignment.
Deadline
Your assignment must be uploaded before or on 21st May 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:
Objectives
The objectives of this assignment are,
1. Giving the idea of the most common tool used for designing database systems i.e. Data Flow Diagram. It is used to design systems graphically and expresses different details of system in different DFD levels.
2. To become familiar with the flow of data between different processes and to hide complexities in any given system.
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.
Note that all the three applications share a central database (as shown in figure-1), deployed on a dedicated database server.
Task Description:
Task-1: [Marks: 10]
You are required to pick one super type/subtype relationship from the above given scenario. Show what type of constraint (Total completeness or partial completeness) exists in the given super type/subtype relationship. Draw the corresponding diagram showing entities, their attributes and relationship.
Task-2: [Marks 10]
Draw cross reference matrix of reports (atleast three) along with their attributes from the above given scenario.
Note: In Task 2 you have to draw cross reference matrix for atleast three we reports.
Good Luck
Dear Students
Please share your idea solution
Database Management System (CS403)
Assignment No. 3
Total marks = 20
Deadline Date: 21/05/2013
Please carefully read the following instructions before attempting the assignment.
Deadline
Your assignment must be uploaded before or on 21st May 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:
- Code:
[You must be registered and logged in to see this link.]
Objectives
The objectives of this assignment are,
1. Giving the idea of the most common tool used for designing database systems i.e. Data Flow Diagram. It is used to design systems graphically and expresses different details of system in different DFD levels.
2. To become familiar with the flow of data between different processes and to hide complexities in any given system.
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.
Note that all the three applications share a central database (as shown in figure-1), deployed on a dedicated database server.
- Code:
[IMG]file:///C:/DOCUME~1/user/LOCALS~1/Temp/msohtmlclip1/01/clip_image001.gif[/IMG]
Task Description:
Task-1: [Marks: 10]
You are required to pick one super type/subtype relationship from the above given scenario. Show what type of constraint (Total completeness or partial completeness) exists in the given super type/subtype relationship. Draw the corresponding diagram showing entities, their attributes and relationship.
Task-2: [Marks 10]
Draw cross reference matrix of reports (atleast three) along with their attributes from the above given scenario.
Note: In Task 2 you have to draw cross reference matrix for atleast three we reports.
Good Luck
ChIntoo- Monstars
- Posts : 92
Join date : 2011-02-13
Similar topics
» ACC311 Assignment No. 1 Solution Spring 2013
» CS506 Assignment No.3 Solution Spring 2013
» CS301 Assignment # 3 Solution Spring 2013
» CS504 Assignment # 2 Solution Spring 2013
» PSY101 Assignment # 1 Solution Spring 2013
» CS506 Assignment No.3 Solution Spring 2013
» CS301 Assignment # 3 Solution Spring 2013
» CS504 Assignment # 2 Solution Spring 2013
» PSY101 Assignment # 1 Solution Spring 2013
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|
Sat May 04, 2024 11:49 am by ali001
» house disrepair claims
Thu May 02, 2024 4:29 pm by Ibad Khan Buledi
» Bounce n Bang: Physics puzzler
Thu May 02, 2024 11:39 am by ali001
» AIChatSY - AIChatbot Assistant
Wed May 01, 2024 10:48 am by ali001
» Storybook Magic App
Tue Apr 30, 2024 7:06 pm by ali001
» Flower Book Match3 Puzzle Game
Tue Apr 30, 2024 12:17 pm by ali001
» Avian Influenza Symptom in Chickens "Bird Flu H5N1 Virus" Vet learning materials, Poultry Farming
Sat Apr 27, 2024 9:57 am by Ibad Khan Buledi
» Aloha Planner - Note-Taker
Thu Apr 11, 2024 4:52 pm by ali001
» Streaming Guide Film TV Series
Tue Apr 09, 2024 9:39 pm by ali001