A. Develop an Entity Relationship Diagram (ERD) to represent the data identified in the information component of work-centred analysis framework for LRS information management system. The diagram of your ERD model must: ï‚· show all necessary entities, attributes and relationships ï‚· show unique identifiers and nature of interaction between entities..

B. Map the ERD into a set of relations in at least Third Normal Form (3NF). You should demonstrate that each relation satisfies the rules for first normal form, second normal form, and third normal form. For example: PROPRIETOR (ProprietorID, FamilyName, GivenName, PhoneNbr) This relation is in 1NF because it does not contain any repeating groups.

In your report you must also include a data dictionary. You should briefly describe all entities and attributes are included, descriptions are clear, reasonable field formats, etc.

 

Task 2:Work Centered Analysis Framework for La Trobe Retail StoreCustomersPerson Who purchases itemsin-store and onlineSuppliers that supply itemsShipping departmentsProductsInformation about the productsto be purchasedInformation about the order ofthe items displayed.Item purchased or delivered tocustomers.Business ProcessCrucial StepsCustomers visits the store or logs on towww.latrobeclothingstore.com.auCustomer enquires about their interested products or searches onlineCustomers look at various products and decide what to orderCustomers bill the ordersProducts dispatched for online orders from warehouseShipping department items prepare for shipping and sends to customersRationale:If the customers cannot access the physical store, they can use the online storewebsite to place orders.ParticipantsCustomers interested inpurchasing clothingSuppliers supplyingorders to storeShipping departmentIn-store staffs to assistcustomersAccounting departmentInformationCustomers order forclothingPrice of the clothsDescription about theitem online.TechnologyBilling computers usedServers used tomaintain online and in-store inventory.PDA’s placed in-storefor easy customeraccess of the items

Attachments:

• 1495758638-Task 2.docx