COIT20247 - Database Design and Development Assignment, Central Queensland University, Australia

EXPERTSMINDS.COM GIVES ACCOUNTABILITY OF YOUR TIME AND MONEY - AVAIL TOP RESULTS ORIGINATED COIT20247 DATABASE IMPLEMENTATION ASSIGNMENT HELP SERVICES AT BEST RATES!

Part A - Database implementation using MS Access

Normalization - Map the ERD, from the sample solution, into a set of relations in at least Third Normal Form (3NF). You must ensure that your relations meet 3NF. There is no need to show your working.

Select any two of your relations from the previous step, 1a), and perform the following for each of those two relations:

List all the functional dependencies exist in the relation.

Demonstrate that the relation meets Third Normal Form (3NF).

Create queries to answer the following information requests. Note: Do not use the Access query builder (QBE) to create your queries - you should type the queries manually using SQL view/editor.

Answer -

Introduction

In the report implantation of the report we will learn about normalization techniques i.e. first normalization, second normalization and many other normalization. In this assignment we will learn to design Microsoft Access database as per the user requirements and learn to design Queries and report in it.

Normalization

Third Normal Relations

Functional Dependency

Customer

Customer (CustomerID, CustomerName, StreetAddress, City, PostCode, CustomerContactNum)

CustomerName → CustomerID

CustomerContactNum → CustomerID

As we see CustomerID is primary key in the customer table so all other field in this table will be depended on this fields.

Employee

Employee (EmployeeID, EmployeeName, Address, EmpStartDate)

EmployeeName → EmployeeID

EmpStartDate → EmployeeID

In the given table EmployeeID will be primary key and all other fields in this table will be depended on it.

Parcel

Parcel (ParcelID,WeightInGram,FromAddress,City,Postcode,DateCollection,ParcelValue,Charges,Status,collectedBy,Customer)

WeightInGram → ParcelID

FromAddress → ParcelID

ParcelID is primary key in the table and collectedBy is foreign key refer to employee table.

In the diagram we see ParcelID is primary key and all other fields are depended on it .This diagram shows the function dependencies.

ENROL WITH COIT20247 DATABASE IMPLEMENTATION ASSIGNMENT HELP AND HOMEWORK WRITING SERVICES OF EXPERTSMINDS.COM AND GET BETTER RESULTS IN COIT20247 DATABASE IMPLEMENTATION ASSIGNMENTS!

SQL Queries

Query 1: Number of Parcel by each parcel status

Query 2: No of parcel which are lost but not claimed

Query 3: Amount paid by each customer

Query 4: Employee details who handle the parcels

Query 5: Employee detail whose name contain 'wheel'

Report

In this report we have included lost parcel details:

24/7 AVAILABILITY OF TRUSTED COIT20247 DATABASE IMPLEMENTATION ASSIGNMENT WRITERS! ORDER ASSIGNMENTS FOR BETTER RESULTS!

Part B - Database implementation using MySQL Server

Consider a simplified version E-R model for the CQPS, where you only deal with three relations Customer, Parcel and Employee (ignore all other relations). Based on this simplified E-R model and using MySQL Workbench, create a database schema with the above three relations, including the primary keys, foreign keys and an E-R diagram.

Answer - The relation between parcel, customer and employee are shown in the diagram.

GET ASSURED A++ GRADE IN EACH COIT20247 DATABASE IMPLEMENTATION ASSIGNMENT ORDER - ORDER FOR ORIGINALLY WRITTEN SOLUTIONS!

Acquire our Central Queensland University, Australia Assignment Help services for major related courses and academic units such as -

• COIT20262 Advanced Network Security Assignment Help
• COIT20270 App Development for Mobile Platforms Assignment Help
• COIT20253 Business Intelligence using Big Data Assignment Help
• COIT20252 Business Process Management Assignment Help
• COIT20260 Cloud Computing for Smart Applications Assignment Help
• COIT20267 Computer Forensics Assignment Help
• COIT11237 Database Design & Implementation Assignment Help
• COIT20256 Data Structures and Algorithms Assignment Help
• COIT12209 Data Science Assignment Help
• COIT20257 Distributed Systems: Principles and Development Assignment Help
• COIT20255 ERP Systems Management Assignment Help
• COIT20250 E-Business Systems Assignment Help
• COIT20259 Enterprise Computing Architecture Assignment Help
• COIT20246 ICT Services Management Assignment Help