Implementing Database Design - Shop Here Case Study - IT/Computer Science Assignment Help

Assignment Task:

CASE STUDY 1: SHOP HERE

Background

Shop Here is a leading departmental store in New York. The store is known for quality products, affordable price range, timely services, and home delivery facility. The store has customers from all sections of the society and procures goods from various countries. Existing System Shop Here maintains an optimum inventory of various categories of items. The details of the various categories are stored in the Categories file. This file contains data about the item category numbers and the corresponding categories. The details of the items are stored in a file named Items. The Items file contains records such as item number, item description, item category number, serial number of the item, unit price of each item, and reorder level of each item. The store has several regular suppliers for the various items. The suppliers are spread over various geographical locations. A detailed record is maintained for each supplier. The supplier record consists of supplier code, supplier’s name, address, phone number, country of origin, and shipment mode number and shipment mode for outstation suppliers. All records are maintained in the Suppliers file.

Envisioned System Shop Here requires a computerized system that provides an effective method of storing transaction details. The inventory-in-charge, Chris Symonds, realizes that with growth in business, it becomes difficult to manually maintain the inventory. Shop Here PURCHASE ORDER FORM Purchase Order ID: Supplier ID: Employee ID: Order Date: Shipment Date: Quantity: Shipment Method ID: Freight Charge: 1.5 Implementing Database Design also wants to include the information about employees who place purchase orders with the suppliers. Therefore, the management of the store has decided to computerize the inventory management of the store. To fulfill this need, the store management has contacted RedSky IT Systems to develop the computerized system. Don Allen, a project manager of RedSky IT Systems, has been deputed to manage the assignment. Don and his project team have:

1. Identified the various entities involved.

2. Identified the attributes of the various entities. The attributes should completely define the entities.

3. Drawn an E/R diagram to demonstrate the relationship between the various entities.

4. Mapped the E/R diagram to tables.

5. Normalized the tables to 3 NF. The normalized tables should have:

a. Table names

b. Field names, datatypes, and size of fields

c. Primary and foreign key identification and integrity

6. Drawn a diagram to show the relationships between various tables.

This IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.