ISYS2038 Database Design and Development Assignment

Assignment Help Database Management System
Reference no: EM132541114

ISYS2038 Database Design and Development - RMIT University

1) Background
In this assignment you are required to demonstrate and apply the concepts and knowledge covered in Week 1 - Week 11. For the purposes of the report, assume that you are employed as a business analyst at Best Innovative Solution (BIS) Pty Ltd. You are assigned to investigate the questions from a new client and provide the solution.

The dataset about Just Decorate Pty. Ltd. has been collected and you are given the following two files for the purpose of applying data analytics:
• dataset (JDCustomers.xlsx)
• header description (JDCustomersDataset-header-description.txt)
These two files are available for download on Canvas | Assignments | Assessment Task 3: Individual Final Assessment | Individual Assignment - Case Study, Specifications and Dataset for the purpose of applying data analytics. Further information about the dataset is listed below:
• The dataset and header description are stored in two separate files.
• The dataset consists of binary, categorical and numerical data.
• There are 6 different attributes and 1000 cases (or instances).
• There are some missing values in the dataset.
• The dataset covers mainly on the aspect of customer related data.

2) Questions from new client
You need to provide answers to all the following questions based on the case study.

Question 1 Data Modelling
• Provide an Entity Relationship Diagram (ERD). For each entity, provide at least one attributes/ fields with a maximum of two attributes (excluding primary key).
• Provide a Relational Model and show the most appropriate attributes/ fields, primary keys and foreign keys. In addition, include the data type for each attribute/ field listed in each table/ entity.
• You should apply third normal form (3NF) and show consistency in the use of notation.
• If you discover while drawing the diagrams that the narrative of case study is incomplete, then provide justifications, assumptions, or reasonable explanations to complete the case study along with your diagrams. You could include the justifications, assumptions or reasonable explanations under Appendix section.

Question 2 SQL Scripts
• Based on data modelling from Question 1, create 3 queries that have the following requirements. Note that each of the query can cover one or more of the requirements.
o One of the 3 queries should have a calculation
o One of the 3 queries should make use of Group By

o One of the 3 queries should include a scalar function (one that returns a value)
o One of the 3 queries should demonstrate Nested Query (could be either standard or correlated sub-query)
o One of the 3 queries should demonstrate joining tables
o One of the 3 queries should demonstrate the creation and testing of Trigger with both valid and invalid test data
• For each query,
o Explain and justify its business purpose
o Provide the SQL script
o Explain the design of SQL script
o Make use of table(s) with sample data to show potential result/ outcome of query

Question 3 Data Analytics with Orange
After you have dealt with the missing values, discuss how you would produce a model to predict the spending score of customers for Just Decorate Pty. Ltd. using the knowledge of data visualisation and regression. In your explanations, include the screenshots of using Orange to produce the visualisation and prediction model. In addition, explain how your results from data visualisation and regression could help Just Decorate Pty. Ltd. to expand its business.

Question 4 Database Administration Approaches
Recommend two security features of database management system that Just Decorate Pty. Ltd. can use to protect the data of the company. Justify each of the recommended security feature.

Question 5 Big Data and Analytics
Suggest two varieties of data sources that Just Decorate Pty. Ltd. can use to further improve the understanding of its business. Provide justifications for each of the suggested data source.

Attachment:- Database Design and Development.rar

Reference no: EM132541114

Questions Cloud

How to evaluate the comment traditional budgeting practices : How to evaluate the comment that 'traditional budgeting practices are constraint on creativity, and the time and energy spent on budget formulation
What steps have you taken to harden systems : What hardening guidelines or standards are you familiar with? What steps have you taken to harden systems?
Explain top down budgeting and bottom up budgeting : Explain top down' budgeting and 'bottom up' budgeting, identify and explain those practice and further explain the behavioural implications of adopted practice
Which strategies allow for the retention of data integrity : Which strategies allow for the retention of data integrity? Which strategies allow for stringent inbound data inspection?
ISYS2038 Database Design and Development Assignment : ISYS2038 Database Design and Development Assignment Help and Solution, RMIT University - Assessment Writing Service
Discuss disadvantages of at least two sampling methods : Explain the advantages and disadvantages of at least two sampling methods. Make a recommendation for the best method to sample accounts receivables
What are your thoughts regarding automated banking : What are your thoughts regarding automated banking and financial tools? Will you utilize them for your business? How can the rise in crowdfunding and angel.
How would recommend the obtain additional funding : Suppose you were providing advice to James and Peter, how would you recommend they obtain additional funding? Be complete in your answer.
What the profit looks like you intend to make : What are the PRICES you want to charge and/or the including a discussion of what the profit looks like you intend to make - "Don't write this one"

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd