SQL developer assignment
generallalaDatabase Concepts Assignment 1 Part A
Due date: Friday, Week 7
Value: 6%
Submission details:
For Internal and External students: submission is via Learnline. Instructions on how to submit the assignment is located under Assessments / Guidelines.
.
Part A: Single and multiple table queries
Please answer all questions.
For each of the first five questions you have to provide the following
· SQL statement (2.5 of the marks)
· Ensure you type the number of records only below your SQL statement (0.5 of the marks)
For question 6 you have to provide the following:
· Written question, SQL statement to answer the question and number of records ( 3 of the marks)
1. List in ascending order the Last Names of all borrowers with Card Number less than 300.
2. Find all borrowers for a loan that have the Date-in before 9-March-15 and the Card number less than 200 in Karama and Darwin.
3. Find the total numbers of loans with last name beginning with A until D; include lastname beginning with S also.
4. Find the number of loans which have been made from each branch?
· Note all branches need to be included even those with no loans
5. What are the records of those loans between 3 June 2014 and 6 June 2015?
· The output should include the name of the card holder, and title of the book.
· List in ascending order by last name and first name
6. Create your own question based on the library Database and with a SQL Statement to answer this.
Page 1 of 2