ITDA1001-Database Fundamentals Report Writings - IT Computer Science Assignment Help

Assignment Task

Task

Case Study:

Video Rental (VR) is a start-up business which allows customer to rent videos. They want to create a database to store the information of their videos, customer, renting details and rental fee charged. VR asked you to create a database for them.

a. Write the SQL queries to create the tables the above. Use appropriate data types for each attribute and choose appropriate primary and foreign keys.

b. Write the Insert query to enter the following sample data into the tables created in Part a. The sample data is provided in the following tables.

c. Write the SQL queries for the tables created in Part a and Part b.

1) Write a query to list all the videos where the cost of the video is between 50 and 75.

2) Write a query to list the details of all customers last names that begin with the letters ‘Kne’

3) Write a query to list the customer id, first name, last name, state and total number of videos borrowed by the customer.

4) Write a query to list each customer first name, last name, the rented video name and due date.

5) Write a query to create a view “BorrowDetails” for the query used in previous question and also display the number of videos each customer has from the newly created view.

Activity 3: Database Administration:

Analyse the database created in Activity 2 and discuss the different types of user access privileges required to maintain the integrity and security of the database. Also, discuss the security issue that may arise if the user inputs are not properly checked before passing them to the database as a query. Provide appropriate examples from a case study.

This  ITDA1001-IT Computer Science Assignment has been solved by our  IT Computer Science Expert at Exam Question Bank. 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 Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.