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.

[Aatika Qasim]

ERD handouts k page no 115 py hy

[17l0x47e3jsyp]

I think we also draw circle to show attributes and i think we should follow diagram on page 117

[Hunniya..(MBS)]

u r right sahiba

[Huma Mughal]

ERD ka jo model draw krna hy kya us main hi in 3 opetion a b r c k ans solve krny hy ja phr seperatly in k ans dyny hy 

(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  

plz tell me about what i do?

[Aatika Qasim]

i think huma is right ERD my hi tino k answer mill jyn gy because ERD my unho ny lines k zariye reation to show kiya hua hy k one to one hy ya one to many hy ya many to many hy lakin attributes kesy zaher krny hyn?

[Rehman Arif]

ap se yeh model bana k nahe mojay b guide kar do

[shoaib hussain]

Student's Message:

Msg No. 724259

Subject: assignment

I want to ask sir that we have to all question differently or we have to draw a diagram and have to explain all three question (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

Post Your Comments Other Students' Comments: 0

Instructor's Reply:

Dear Maryam, All these things are part of ERD, separately mentioned to avoid any confusion and for better understanding. Regards,

[sadaf ch.]

ok

[Aatika Qasim]

kiya instructor kehna chahty hyn k alag alag bana skty hyn?

[hira malik]

diagram k ander hi a b or c ka ans ho alag se nhi krna

[Rana Riaz Ahmed Anjum]

plz anyone tell me the merit and demerit of ERD

[Rehman Arif]

please help me mojay tu kuch samaj nahe a rahe