Assignment Task
Task
Case Study:
A-Plus Writing Help For University Students
Get expert assistance in any academic field. All courses and programs covered.
Get Help Now!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 TV Assignment Help. 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.
Welcome to our Online Essay Writing Agency. Securing higher grades costing your pocket? Order your assignment online at the lowest price now! Our online essay writers are able to provide high-quality assignment help within your deadline. With our homework writing company, you can order essays, term papers, research papers, capstone projects, movie review, presentation, annotated bibliography, reaction paper, research proposal, discussion, or another assignment without having to worry about its originality – we offer 100% original content written completely from scratch
We write papers within your selected deadline. Just share the instructions