::: vuaskari.com ::: CS403 Assignment No. 03 Discussion and idea solution

Assignment_File_Spring 2013_CS403_3

Dated: May 15, 13

Dear Students,

Assignment 3^rd of CS403 (Database Management System) has been announced and uploaded on 15^th May 2013. You are required to upload your solution by 21^st of May 2013. Read the instructions carefully before solving the assignment and then upload your solution.

Thanks,

Regards,

Instructor CS403

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

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en

Re: ::: vuaskari.com ::: CS408 - FINAL TERM SUBJECTIVE WITH REFERENCE SOLVED BY UMAIR SAULAT

GREAT WORK On Wed, Feb 20, 2013 at 11:30 PM, Umair Saulat < saulat.umair@gmail.com > wrote: CS408- Human Computer Interaction Solved Subjective Fall Semester 2012 QNo.1 it has been observed that most computer users use menu option for input instead of keyboard accelerator. What is the reason behind it? (2 Marks) Answer:- 1. Menu options are easier to find. 2. You don't have to memories the keys for menu option but for key board accelerators you have to memories them REF:: Handouts Page No. 127 QNo.2 Define active intervention. (2 Marks) Answer:- Active intervention with the participant and actively probes the participant understands of whatever is being tested. REF:: Handouts Page No. 276 QNo.3 what is Ubiquitous Computing? (2 Marks) Answer:- The most profound technologies are those that disappear. They weave themselves into the fabric of everyday life until they are indi

Updating our Google Account inactivity policy

Every day Google works hard to keep you and your private information safe and secure by preventing unauthorized access to your Google Account with our built-in security protections. And keeping you safe means having strong privacy practices across our products that minimize how long we store your personal files and any data associated with them. We want to protect your private information and prevent any unauthorized access to your account even if you're no longer using our services. Therefore, we are updating the inactivity period for a Google Account to two years across all our products and services. This change starts rolling out today and will apply to any Google Account that's been inactive, meaning it has not been signed into or used within a two-year period. An inactive account and any content in it will be eligible for deletion from December 1, 2023. What this means for you: These changes do not impact you unless you h

Learn more about our updated Terms of Service

stargthb@gmail.com On January 5, 2022, we're making some changes to our Terms of Service. These changes won't affect the way you use Google services, but they'll make it easier for you to understand what to expect from Google — and what we expect from you — as you use our services. You can review the new terms here . At a glance, here's what this update means for you: More clarity on what you can expect from Google and what we expect from you : We're providing more examples to describe the mutually respectful conduct that we expect from all our users. Improved readability : While our terms remain a legal document, we've done our best to make them easier to understand, including reorganizing some topics so that they're easier to find. If you use Family Link to manage a Google Account for someone else, please take some time to talk to them about these changes. Thank you for using Google!

VU Study

Search This Blog