CS507 Assignment Scenario:
https://www.24hours.pk/ is an online shopping website, which facilitate customers with hassle free buying of discount products over internet. Customers can buy any kind of products such as mobiles, electronics, clothes etc. Customers can pay bill online very easily. A brief description of the website is as follows:
To sign up into https://www.24hours.pk/, a new customer has to register himself/herself for online shopping. The customer provides his/her first-name, last-name, mobile no, email id, home address, city, and password in sign up form. Now customer can sign in providing his/her credentials. The customer can purchase any product such as mobiles, electronics, and clothes etc. Each product has its product id and product name, product description, and product price. A customer can purchase more than one products. Customer can pay the bill online by filling a shipment voucher by providing his full name, contact number, address, city, and payment mode (cash or credit card). Customer can pay more than one bill from his bank account.
Now, by keeping the above scenario, you are required to:
Question no 1:
Identify the entities and the related attributes. (5 Marks)
Question no 2:
List down the type of attributes in appropriate column of below table. (5 Marks)
Multi value attributes Derived attributes Composite attributes
Question no 3:
Design Entity Relationship Diagram (ERD), showing proper relationship among the entities. (10 Marks)
http://vujannat.ning.com/ Best Website To Help Students OF VUhttp://vujannat.ning.com/ Best Website To Help Students OF VU
Question 1: What are the organization, management and technology dimensions of information systems? [3 marks]Answer:An information system represents a combination of management, organization, andtechnology elements. The management dimension of information system involvesleadership, strategy, and management behavior. The technology dimension consists of computer hardware, software, data management technology, andnetworking/telecommunication technology (including the internet). The Organizationdimension of information system involves the organization’s hierarchy, functionalspecialties, business processes, culture, political interest groups.Question 2: Describe some of the major changes that information systems are bringing toorganizations. [3 marks]Answer:The flattening of organizations is probably one that students will cite, particularly withthe concern over downsizing. The parallel increase in information and in the decisionpower of line workers (empowerment), and their corresponding increase in work satisfaction, is often missed in media reports of downsizing. The flexibility of organizations in operations, for example, custom manufacturing and in linking customersand suppliers (thus reducing order time) are some of the major changesQuestion 3: Describe the two factors that explain why organizations adopt informationsystems. [4 marks]Answer:• Customers now prefer to execute transaction in an electronic environment throughonline-trading. Also the establishment of customer services centers has also removed theinconvenience to access vendor’s physical locations.• Due to absence of physical contact, companies are curious to keep a soft touch in anefficient manner. This requires keeping a customer-wise online track of pastcorrespondence and transactions.