ISYS2095 - Database Design and Research & Concepts - Report Writing - IT Assignment Help

Assignment Task -                 

Overview 

The objective of this assignment is to review most of the skills studied in the course: database design and SQL.  The assessment is in two parts as follows: 

1. Relational Database Design 

2. SQL

To complete this assessment, you will need to install SQLite Studio. The instructions for installing, configuring and  using SQLite Studio are provided in Week 2. In this assessment, you will create your own database in SQLite 

Assessment Criteria 

This assessment will measure your ability to: 

• Explain the main concepts for data modelling and characteristics of database systems.  

• Identify issues with and compare, justify relational database design using the functional dependency  concepts.  

• Apply SQL as a programming language to define database schemas and update database contents. 

• Apply SQL as programming language to extract data from databases for specific users’ information  needs  

• Design a database schema using conceptual modeling mechanisms such as entity-relationship  diagrams

Learning Outcomes 

This assessment is relevant to the following Course Learning Outcomes: 

1 CLO 2: Explain the main concepts for data modeling and characteristics of database systems.  

2 CLO 3: Identify issues with and compare, justify relational database design using the functional  dependency concepts.  

3 CLO 4: Apply SQL as a programming language to define database schemas and update  database contents.  

4 CLO 5: Apply SQL as programming language to extract data from databases for specific users’  information needs  

5 CLO 6: Design a database schema using conceptual modeling mechanisms such as entity relationship diagrams.

Part A Relational Database Design 

Task 1: ER Modelling and Relations 

Consider building a database for a shopping mall with requirements as follows: 

1 Each product of the shopping mall has a unique project No, and also has a name, a supplier  name, a category, a purchase price and a selling price. 

2 Products need to be supplied from suppliers. Each product has one supplier, but a supplier  may supply many products for the shopping mall. 

3 Each supplier has a supplier name and address. 

4 A purchase order for product from a supplier has a unique order No, and a date. The order  specifies one or more products and their quantities required for a product.  

5 A sales order for product to customers has a unique order No, and a date. The order specifies  one or more products and their quantities required for a product 

6 The shopping mall has warehouses. Each warehouse has a warehouse number, an address  and a contact phone number. Each warehouse has shelves to store products. Each shelf has a  shelf-number and a capacity. The shelf number is not unique across warehouses, but it is  unique within each warehouse. For example, warehouse A has only one shelf numbered as 14  and warehouse B may also have one shelf numbered as 14. 

7 Products are sent to warehouses for storage. For the ease of product distribution, the shopping  mall records the warehouses and shelf-numbers for storing each product, together with the  quantity for the product. 

8 Each customer of the shopping mall is identified by a customer ID. 

9 Information about shopping mall employees includes a unique employee ID, and his/her name  and position.  

10 Some customers are VIP customers who are identified by a membership number and have a  name and contact number. While a VIP customer is serviced by one service specialist (who is  an employee). A service specialist cares for several VIP customers. 

11 Customers can place multiple purchase orders. Each order is described by the date of the  order and quantity of the clothes s/he orders. VIP customers can receive a discount rate on  their purchase. 

Task 1.1  

Based on the information you gathered, model the activities of the shopping mall and present your model as  an Entity-Relationship (ER) diagram. In your ER diagram, you must properly denote all applicable concepts,  including weak or strong entities, keys, composite or multi-valued attributes; relationships and their  cardinality and participation constraint.

Task 1.2  

Once you have completed your ER model, map it to a relational database schema. Show every step of  the mapping. No marks are awarded to the final schema if you do not show the partially built schema  at the end of each step. Indicate the primary key (underlined) and foreign key (with an asterisk) in each  relation. 

This ISYS2095 - IT Assignment has been solved by our IT 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.