Question Number 1 Marks: 5

Develop an Entity-relationship diagram for a TCS parcel delivery company which uses system-wide information for all the parcels it delivers. All parcels are identified by their tracking number and is associated with different parameters including weight, dimension, destination, delivery date, sender and receiver addresses. All items are received at various distribution centers across the country and are identified by their unique id, type and their addresses. All parcels make their way to the destination via one or more standard transportation methods (i.e. flights, delivery trucks, motorcycles, these transportation methods are characterized by their unique type, id and transportation identification number.

Rubrics (Grading Criteria)

Entities and attributes correctly identified: 50%

Primary keys correctly identified: 20%

Relationship correctly identified: 30%

Question Number 2 Marks: 5

The Big Nine's Artificial Intelligence systems by Google, Microsoft, Amazon, Facebook, IBM, Apple, Baidu, Alibaba, and Tencent are increasingly accessing our real-world data to build products that show commercial value. List down the risks that involved in implementing of such a system which can learn from human interaction, emotions, and behavior. Identify the goals that these companies want to achieve from the implementation of AI technologies? What is the acceptable level of evolution of A.I. at which people will be willing to compromise for data collection?

Rubrics (Grading Criteria)

Explanation: 50%

Identification: 50%

Question Number 3 Marks: 5

Digital social networks (such as Facebook and Twitter) are very popular with individuals. Identify the reason that why individuals will prefer Digital social network over casual social networking or vice versa. List down mental health problems that may arises with excessive use of digital social networking Do we ever need to be concerned about becoming addicted to any Internet activities? Find one example in a news or journal article of a person who was addicted to using a social networking site or other online activity.

Rubrics (Grading Criteria)

Coverage: 50%

Example with citations: 20%

Comparison: 30%

Question Number 4 Marks: 5

List down and describe several strategies for implementing e-commerce using the Web, including some of the decisions that need to be made, selecting the appropriate business model, the options available for accepting payments, and the process of designing and developing an effective Web site.

Rubrics (Grading Criteria)

Explanation: 40%

Coverage: 30%

Justification: 30%

Question Number 5 Marks: 5

With the help of diagrams, explain various data delivery methods in large telecommunication networks where data delivery is characterized by success-ratio of the delivery, time taken for data to travel from source to destination and the route the data took in order to reach its destination.

Rubrics (Grading Criteria)

Diagram: 60%

Explanation: 40%

Question Number 6 Marks: 5

A small manufacturing company is expanding by its business by opening multiple branches across the country. Currently all the database is managed by individual employees on Microsoft Excel or sometimes using Microsoft Access. The company is considering updating to a central database management system comprising of several modules for maintaining their manufacturing, inventory, employees and accounting requirements. You are hired to develop a feasibility report as the first phase of the SDLC cycle including the recommendations on economic, operational, technical aspects of the on-going project.

Rubrics (Grading Criteria)

Report Writing: 50%

Examples: 30%

Closing Statement: 20%

Question Number 7 Marks: 5

A multinational company opens multiple branches all over that Pakistan. If you are hired to design the networking from the company, what type of network you will select? What type of network topology will be suitable for the linking different branches or different department inside the single company branch? List down the network equipment you may require during this implementation.

Rubrics (Grading Criteria)

Reasoning: 60%

Equipment selection: 40%

Question Number 8 Marks: 5

If you decided to open a photo studio and printing gallery. You planned to hire worker for financial, photographic, and editing work. Select the software and hardware that you will provide to the workers in each of the department. Justify the need of that software and hardware (provide specification with estimated cost) that you purchase for the department. How they store their data backup and which backup storage technique should be used?

Rubrics (Grading Criteria)

Software selection: 25%

Hardware selection: 25%

Backup selection: 25%

Cost breakdown and effectiveness: 25%