COMP7240 Introduction to Database Concepts : Data Processing Concepts

COMP7240 Introduction to Database Concepts : Data Processing Concepts

$20 Bonus + 25% OFF

Securing Higher Grades Costing Your Pocket?
Book Your Assignment at The Lowest Price
Now!

Students Who Viewed This Also Studied

COMP7240 Introduction to Database Concepts

Questions:

Write SQL queries for the following tasks.

Display full names of publishers with whom the author Alfred Aho did not publish his book(s). Your query must use IN (/NOT IN) clause.

    1. Display all the information of books on the subject “DataBases”.
    2. Display the first name and last name of the persons who borrow books on the subject “DataBases”.

      a. Write your query using a sub query.

      b. Write your query using JOINs.
    3. Who borrowed the book ” COMPUTER SCIENCE “? Display the first name, middle names, and last name of the borrower.
    4. Display the titles of books that are currently being borrowed.
    5. A borrower wants to borrow the book titled ” Data Processing Concepts”, but all of its copies are already borrowed by others. Write two queries to display other recommended titles using the following methods.

      a. Using partial matching of the book title — note that the borrower is interested in a “DATA” book.

      b. By searching of other books written by the same author (i.e. the author of ” DATA PROCESSING CONCEPTS”

    6. Display the list of publishers who have not published books on the subject “DataBases”. Your query should display publisher’s full name.


    1. Display the name of persons who have never borrowed any books.

      a. Write your query using OUTER JOINs.

      b. Write the query again without using OUTER JOINs.


    1. Display the first name and last name of persons who had borrowed more than 3 books. Along with each name, display the number of books as well.


  1. Display the name of the person who had borrowed most copies. If there are more than one person with the highest number of borrowing copies, show them all. Your query should show the names.

Provide detailed answers to the following questions.

  1. According to this database schema, it is assumed that all booked borrowed in one transaction are due at the same time. However, this is an unreasonable assumption and quite contrary to the common practice across all forms of libraries. The books may be due on different days due to the renew activity.

Provide the required changes to the database schema to accommodate this requirement. Your answer should include a portion of the ER model where the changes are applied and the updated relational database schema. If required, you may add new relations and attributes and also new foreign keys.


  1. Libraries allow customers to place holds onto book, but not borrow it immediately. It can be borrowed by the customer who places the hold within one week. This database schema cannot keep information on holding of books. Extend this schema to accommodate this requirement. Your answer should include a portion of the ER model where the changes are applied and the updated relational database schema. If required, you may add new relations and attributes and also new foreign keys.
  2. The library allows customers to return the books in one transaction separately. Can this database schema support this operation? If so, how are they handled? If not, what changes required to the database schema?

COMP7240 Introduction to Database Concepts

Answer in Detail


Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

14 More Pages to Come in This Document. Get access to the complete answer.

We are an assignment help service brand that can provide any kind of academic assignment help. MyAssignmenthelp.com is backed by 3000+ writers who have obtained their degrees from prestigious international universities. Each one of them can provide online assignment help in their field of specialization. We have such a huge team of writers since we provide assignment help services in 100+ academic subjects. Our PhD level expert writers can provide a wide range of services like online assignment help, dissertation writing services, custom essay help and homework help. Our writers serve students from many nations like Australia, UK and US. If you have any assignment related query, then we have a 24×7 live chat support facility for you.

More COMP7240 COMP7240 Introduction to Database Concepts: Questions & Answers

Create and Query Databases using SQL

TaskWrite SQL statements to answer the following questions from the ‘assignment5’Database: Answer all questions1.    List all the record/s in the vendor table that do not have a value for the attribute V_STATE.2.    Find the customers whose balance is greate …

View Answer

Organisation Values

detail about HOW and WHY it does what it does o    The report needs to be consistent, with all sections supporting each other towards making the reader understand system o    Use professional report format – so title page, short executive summary, contents page, n …

View Answer

Business Management

PREAMBLE Dr William Moulton Marston retired in 2012 after a long career in Pyschology. To keep busy and to fulfil a lifelong dream, Dr Moulton Marston started a Memorabilia mail order business, specialising in Superhero related products called the “Themyscira Paradise” and began selling …

View Answer

Management

the assignment case study is in file assignment case study and you have all your requirements to look into and it is a 3000-word assignment and you have to follow the template very strict because if the template is changed or size or font is changed also there is a high chance of getting fewer marks …

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the
content removal request.

Choose Our Best Expert to Help You





Beck Archer

I got my MBA degree from Odette School of Business.

400 – Completed Orders

Hire Me





Winston Larsen

I have got my Master’s in Economics from the National University of Singapore.

800 – Completed Orders

Hire Me





Bria Contreras

I have finished my education at the University of Bristol with MA in English literature.

598 – Completed Orders

Hire Me





Chew Soo

Pursuing PhD in Biology with Specialization in Medicine

3812 – Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

HRM

Assignment: 6 Pages, Deadline:
22 days

I am really happy with the result, even though I had to make adjustments, and I got a good grade for it.

User ID: 5***20 France

Marketing

Home Work: 1 Page, Deadline:
3 days

Thank you so much! taking a time to do Thank you so much! taking a time to do my assignment my assignment

User ID: 6***98 United States

Assignment

Essay: 4.8 Pages, Deadline:
10 days

A very well presented assignment, all the ideas were very well explained, easy to understand. Definitely will recommend .

User ID: 8***07 Denmark

Business Law

Home Work: 0.9 Pages, Deadline:
1 day

Thank you, very much ????????????! I’m looking forward to working with you guys again.

User ID: 8***94 Canada

Medical

Essay: 1.6 Pages, Deadline:
3 days

This assignment was good I got a really good grade on this assignment so who complete this one great job.

User ID: 8***56 United States

Pharmacy

Assignment: 1 Page, Deadline:
3 days

This assignment was okay but I felt that it could have gotten a better grade but assignment was good.

User ID: 8***56 United States

Marketing

Home Work: 1 Page, Deadline:
11 days

Very reliable work. I liked the quality of assignment. They delivered two days before the day of commitment.

User ID: 8***50 Australia

Management

Assignment: 6 Pages, Deadline:
5 days

Good work and very fast turn around. Happy with the quality of assignment. Definitely would recommend.

User ID: 8***50 Australia

Assignment

Essay: 2 Pages, Deadline:
3 days

Very quick done and professional job. Helped me to gain good marks. Easy to read as answers given very clear.

User ID: 5***21 Blanchardstown, Ireland

Statistics

Home Work: 3 Pages, Deadline:
11 hours

Thank you very much… YOU ARE A GREAT WRITER ! You provide this answer and saved my life !

User ID: 8***32 Blanchardstown, Sri Lanka

Civil Law

Home Work: 3.6 Pages, Deadline:
4 hours

Thanks for the time response and helped me in successfully submitting the assignment. Thanks for this time

User ID: 8***31 United Kingdom, Great Britain

Economics

Home Work: 1.2 Pages, Deadline:
2 hours

Thanks for helping at short notice. Great quality, in the short time provided. All the best

User ID: 8***61 United Kingdom, Great Britain

Management

Assignment: 5 Pages, Deadline:
5 days

This report addresses the assignment brief very well, with much detail on Unilever online presence. The recommendation are good, and more detail/ less …

User ID: 8***01 England, Great Britain

Maths

Home Work: 1 Page, Deadline:
54 minutes

Super quick response time, great detail and construction of the solution. Many thanks for your help in this assignment. All the best

User ID: 8***61 United Kingdom, Great Britain

Maths

Home Work: 1 Page, Deadline:
1 hour

The new answer seems correct and is well explained in detail. Thank you for reviewing the work and for your help on this assignment. All the best.

User ID: 8***61 United Kingdom, Great Britain

Maths

Home Work: 1 Page, Deadline:
1 hour

Very good solution, well explained in detail. Thank you very much for your help on this assignment. All the best.

User ID: 8***61 United Kingdom, Great Britain

Finance

Essay: 4 Pages, Deadline:
7 days

Awesome work! I am fully satisfied with the quality of the content. The writers worked hard to deliver such a deep and wide content. Keep it up.

User ID: 8***46 Batu Caves, Malaysia

Nursing

Assignment: 1 Page, Deadline:
4 days

This powerpoint was neat and concise. The expert definitely followed through with what was asked.

User ID: 6***42 Batu Caves, United States

Nursing

Assignment: 12 Pages, Deadline:
5 days

well written assignment. good references and all done in a timely manner. pricing was good and support available when needed

User ID: 6***93 United Kingdom, Great Britain

Maths

Course Work: 0.4 Pages, Deadline:
2 hours

Great, very clear, thank you very much For your help on this assignment. All the best

User ID: 8***61 United Kingdom, Great Britain

HRM

Assignment: 6 Pages, Deadline:
22 days

I am really happy with the result, even though I had to make adjustments, and I got a good grade for it.

User ID: 5***20 France

Marketing

Home Work: 1 Page, Deadline:
3 days

Thank you so much! taking a time to do Thank you so much! taking a time to do my assignment my assignment

User ID: 6***98 United States

Assignment

Essay: 4.8 Pages, Deadline:
10 days

A very well presented assignment, all the ideas were very well explained, easy to understand. Definitely will recommend .

User ID: 8***07 Denmark

Business Law

Home Work: 0.9 Pages, Deadline:
1 day

Thank you, very much ????????????! I’m looking forward to working with you guys again.

User ID: 8***94 Canada

Medical

Essay: 1.6 Pages, Deadline:
3 days

This assignment was good I got a really good grade on this assignment so who complete this one great job.

User ID: 8***56 United States

Pharmacy

Assignment: 1 Page, Deadline:
3 days

This assignment was okay but I felt that it could have gotten a better grade but assignment was good.

User ID: 8***56 United States

Marketing

Home Work: 1 Page, Deadline:
11 days

Very reliable work. I liked the quality of assignment. They delivered two days before the day of commitment.

User ID: 8***50 Australia

Management

Assignment: 6 Pages, Deadline:
5 days

Good work and very fast turn around. Happy with the quality of assignment. Definitely would recommend.

User ID: 8***50 Australia

Assignment

Essay: 2 Pages, Deadline:
3 days

Very quick done and professional job. Helped me to gain good marks. Easy to read as answers given very clear.

User ID: 5***21 Blanchardstown, Ireland

Statistics

Home Work: 3 Pages, Deadline:
11 hours

Thank you very much… YOU ARE A GREAT WRITER ! You provide this answer and saved my life !

User ID: 8***32 Blanchardstown, Sri Lanka

Civil Law

Home Work: 3.6 Pages, Deadline:
4 hours

Thanks for the time response and helped me in successfully submitting the assignment. Thanks for this time

User ID: 8***31 United Kingdom, Great Britain

Economics

Home Work: 1.2 Pages, Deadline:
2 hours

Thanks for helping at short notice. Great quality, in the short time provided. All the best

User ID: 8***61 United Kingdom, Great Britain

Management

Assignment: 5 Pages, Deadline:
5 days

This report addresses the assignment brief very well, with much detail on Unilever online presence. The recommendation are good, and more detail/ less …

User ID: 8***01 England, Great Britain

Maths

Home Work: 1 Page, Deadline:
54 minutes

Super quick response time, great detail and construction of the solution. Many thanks for your help in this assignment. All the best

User ID: 8***61 United Kingdom, Great Britain

Maths

Home Work: 1 Page, Deadline:
1 hour

The new answer seems correct and is well explained in detail. Thank you for reviewing the work and for your help on this assignment. All the best.

User ID: 8***61 United Kingdom, Great Britain

Maths

Home Work: 1 Page, Deadline:
1 hour

Very good solution, well explained in detail. Thank you very much for your help on this assignment. All the best.

User ID: 8***61 United Kingdom, Great Britain

Finance

Essay: 4 Pages, Deadline:
7 days

Awesome work! I am fully satisfied with the quality of the content. The writers worked hard to deliver such a deep and wide content. Keep it up.

User ID: 8***46 Batu Caves, Malaysia

Nursing

Assignment: 1 Page, Deadline:
4 days

This powerpoint was neat and concise. The expert definitely followed through with what was asked.

User ID: 6***42 Batu Caves, United States

Nursing

Assignment: 12 Pages, Deadline:
5 days

well written assignment. good references and all done in a timely manner. pricing was good and support available when needed

User ID: 6***93 United Kingdom, Great Britain

Maths

Course Work: 0.4 Pages, Deadline:
2 hours

Great, very clear, thank you very much For your help on this assignment. All the best

User ID: 8***61 United Kingdom, Great Britain

Have any Query?

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER