ARE YOU LOOKING FOR RELIABLE DATABASE IMPLEMENTATION ASSIGNMENT HELP SERVICES? EXPERTSMINDS.COM IS RIGHT CHOICE AS YOUR STUDY PARTNER!
Part A. Database implementation using MS Access
Introduction
In this report we will include the step for designing the MS access database. In this task we will learn to design table and how to relate it with each other. We will also learn to design queries and sub queries. And also learn the concept of join and like operators.
Question. Normalization
Answer:
A) - List all the functional dependencies exist in the relation.
Functional Dependency
Customer
![Functional Dependency1.jpg](https://www.expertsminds.com/CMSImages/352_Functional Dependency1.jpg)
CustomerID is primary key in this table and all other fields are related to it.
Employee
![Functional Dependency2.jpg](https://www.expertsminds.com/CMSImages/1424_Functional Dependency2.jpg)
In this table EmployeeID is primary key and all other field will be related to it.
Parcel
![Functional Dependency3.jpg](https://www.expertsminds.com/CMSImages/235_Functional Dependency3.jpg)
Here ParcelID is related to each fields of the table and it is primary key in this table.
SAVE YOUR HIGHER GRADE WITH ACQUIRING DATABASE IMPLEMENTATION ASSIGNMENT HELP & QUALITY HOMEWORK WRITING SERVICES OF EXPERTSMINDS.COM
B) - Demonstrate that the relation meets Third Normal Form (3NF).
Third Normal Relations
![Third Normal Relations.jpg](https://www.expertsminds.com/CMSImages/1133_Third Normal Relations.jpg)
Question 2 Relational database implementation
Answer:
Creating Tables
1. Customer Table
![Creating Tables.jpg](https://www.expertsminds.com/CMSImages/2070_Creating Tables.jpg)
2. Employee table
![Creating Tables1.jpg](https://www.expertsminds.com/CMSImages/429_Creating Tables1.jpg)
3. Parcel
![Creating Tables2.jpg](https://www.expertsminds.com/CMSImages/2326_Creating Tables2.jpg)
4. Invoice
![Creating Tables3.jpg](https://www.expertsminds.com/CMSImages/155_Creating Tables3.jpg)
5. ParcelFromAddress
![Creating Tables4.jpg](https://www.expertsminds.com/CMSImages/218_Creating Tables4.jpg)
6. ParcelToAddress
![Creating Tables5.jpg](https://www.expertsminds.com/CMSImages/1445_Creating Tables5.jpg)
7. Delivered
![Creating Tables6.jpg](https://www.expertsminds.com/CMSImages/2212_Creating Tables6.jpg)
8. Returned
![Creating Tables7.jpg](https://www.expertsminds.com/CMSImages/2057_Creating Tables7.jpg)
9. Lost
![Creating Tables8.jpg](https://www.expertsminds.com/CMSImages/2259_Creating Tables8.jpg)
10. Claim
![Creating Tables9.jpg](https://www.expertsminds.com/CMSImages/583_Creating Tables9.jpg)
DO YOU WANT TO EXCEL IN DATABASE IMPLEMENTATION ASSIGNMENT? HIRE TRUSTED TUTORS FROM EXPERTSMINDS AND ACHIEVE SUCCESS!
Create queries to answer the following information requests.
Queries
Query 1: For each kind of delivery status find out the number of parcels. Display the delivery status and the corresponding number of parcels.
![Query 1.jpg](https://www.expertsminds.com/CMSImages/2106_Query 1.jpg)
Query 2: Display the number of parcels that have been lost but have not been claimed yet for any compensation.
![Query 2.jpg](https://www.expertsminds.com/CMSImages/1570_Query 2.jpg)
Query 3: Display the details of the customers who have contributed the maximum amount of charges to CQPS through all of their parcel delivery orders.
![Query 3.jpg](https://www.expertsminds.com/CMSImages/243_Query 3.jpg)
Query 4: List the details of employees who have handled/involved with at least five parcels and at the same time have not been involved with any of the lost parcels. Display their details in ascending order of their name.
![Query 4.jpg](https://www.expertsminds.com/CMSImages/558_Query 4.jpg)
Query 5: Display the details of employee(s) whose name contains the word "wheel".
![Query 5.jpg](https://www.expertsminds.com/CMSImages/1856_Query 5.jpg)
WORK TOGETHER WITH EXPERTSMIND'S TUTOR TO ACHIEVE SUCCESS IN DATABASE IMPLEMENTATION ASSIGNMENT!
Report
Create a simple report object showing the details of parcels that have been lost. The report should also display the details of senders of the parcels and the employees who collected them.
![Report.jpg](https://www.expertsminds.com/CMSImages/2443_Report.jpg)
Part B: Database implementation using MySQL Server
![ER Model.jpg](https://www.expertsminds.com/CMSImages/1195_ER Model.jpg)
EXPERTSMINDS.COM ACCEPTS INSTANT AND SHORT DEADLINES ORDER FOR DATABASE IMPLEMENTATION ASSIGNMENT - ORDER TODAY FOR EXCELLENCE!
Listed below some of the major courses cover under our Central Queensland University Assignment Help Service:-
- COIT11237 Database Design & Implementation Assignment Help
- COIT20256 Data Structures and Algorithms Assignment Help
- COIT11240 Dashboard Design and Visualisation Assignment Help
- COIT12212 Cyber Security Management Assignment Help
- COIT20257 Distributed Systems: Principles and Development Assignment Help
- COIT20255 ERP Systems Management Assignment Help
- COIT12201 Electronic Crime and Digital Forensics Assignment Help
- COIT20250 Emerging Technologies in E-Business Assignment Help
- COIT20250 E-Business Systems Assignment Help