Assignment no 3

[bilal ch]

Objective: Practical understanding of Information Systems. This assignment has been designed to develop ability to design ERD and for understanding of Web Architectures. (Covers Lecture 23-28)

1. A company ABC has a website for record management of its employees. Login is assigned to every new employee so he can access and manage his information. Personal information (including dependents) of an employee is maintained. He can check his monthly salary slip online. After probation period, he can apply for loan from company according to his pay scale by filling form. Moreover, he marks attendance online and can check previous attendance log.
At least 1 project is assigned to each employee and he can check project related information and reports on website.
you are required to:
(a) Draw an ER-Model (Entity Relationship Diagram) for above scenario
(b) Add basic attributes for entities (with identification of primary key)
(c) Include types of relationship (15 Marks)
2. A software company “Vision” has its head office in USA. It hires developers from Pakistan which are working offshore for their project. Access of its online web portal has been given to development team so they may access and work online on different applications. Company checks online work status regularly.
Vision needs privacy for online contents and applications with access only to its team in Pakistan. It has low budget to pay for internet services.
(a) Which internet /web architecture is suitable for “Vision”?
(b) Write at least 3 major benefits of adopted web architecture (5 Marks)
Note. Copied answer through any source will get zero marks. Moreover, a good assignment submitted by the student will be declared as excellent and will be acknowledged.

[Hunniya..(MBS)]

atika ap ny as its ntes wala yhi erd yaha show kurwa dia hy. kindlty rechk ur assigmnt againn

[Aatika Qasim]

kindly ap muje clear karo gi k kahan mistake hyn?

[dunya naseer]

ye link ni khul rha

[dunya naseer]

aatika 1 project is assigned to one employee tou ye one to one relationship ni ho ga?

[Rana Riaz Ahmed Anjum]

Sis

a)-VPN

b)-1-Remotely access to information

    2-Secure Network

     3-Anonymity 

[Rabia Usman]

VPN hta hai dear

[Aatika Qasim]

(b) Add basic attributes for entities (with identification of primary key)
ans
composite
multi valued
null
drived.
konsa chose karyn....?

(c) Include types of relationship (15 Marks)
ans
many to one
many to many
i think many to many hy

[Rana Riaz Ahmed Anjum]

i think 

Many to many

[Aatika Qasim]

but rana i think just erd my hi sab show karna hy

Q k Handouts ,y jo ERD bani hy us my jo lines hyn wo khud show kar rahi hyn k kahan many to many relationship hy r kahan py many to one hy or kahan py one to one hy
ATTRIBUTES kon sa?

[Aatika Qasim]

Agr ERD my dekhyn to us ny arrows sy relation show kiya hua hy k many to many hy many to one hy ya one to one hy

[Rana Riaz Ahmed Anjum]

koi ab ERD men help kare ga

[Aatika Qasim]

ERD hands out my bani hue hy