Help in Normalization in SQL Database
Budget: ₹600 – ₹1,500 INR
Normalise the data that you have been given to 3rd Normal Form (3NF).
Create a fully annotate ER Diagram.
Implement the SQL Database and populate with the data provided.
Complete the following Queries:
1. Show all orders by customer in ascending order of total value of each order.
2. Show orders that have not yet been delivered to customers.
3. Show the details of the customer with the highest value order.
4. Show the items sold in descending order of value.
5. List all unsold items in ascending order of item number.
Design and Implement the database as specified above and provide answers to the queries using a NoSQL Database System. Use Mongo DB or another NoSQL database available at UWE. Create the database and populate with the relevant data.
Provide answers to the queries defined in Task1
Discuss the topic of personal data protection.
Identify the elements of the GDPR that apply to the data that you have been given Is there any risk for the antiques dealer with the data that they keep? Could they be exposed in violation of the data protection act?
Maximum length 600 words
Create a fully annotate ER Diagram.
Implement the SQL Database and populate with the data provided.
Complete the following Queries:
1. Show all orders by customer in ascending order of total value of each order.
2. Show orders that have not yet been delivered to customers.
3. Show the details of the customer with the highest value order.
4. Show the items sold in descending order of value.
5. List all unsold items in ascending order of item number.
Design and Implement the database as specified above and provide answers to the queries using a NoSQL Database System. Use Mongo DB or another NoSQL database available at UWE. Create the database and populate with the relevant data.
Provide answers to the queries defined in Task1
Discuss the topic of personal data protection.
Identify the elements of the GDPR that apply to the data that you have been given Is there any risk for the antiques dealer with the data that they keep? Could they be exposed in violation of the data protection act?
Maximum length 600 words