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