ITC114: Please discuss the usage of the composite entities in ERD with an example. The owner of a company employed you: Database Management Systems Assignment, CSU, Australia

University Charles Shurt University (CSU)
Subject Database Management Systems
  • Please discuss the usage of the composite entities in ERD with an example.
  • The owner of a company employed you as a ‘Database Consultant’ and the owner is not convinced that the company needs to move to a database system to manage their customers’ data. Currently, the company uses a ‘file system’. What will you say to the owner of the company with regard to the limitations in the ‘file system’ currently in use?
  • What two conditions must be met before an entity can be classified as a weak entity? Give an example of a weak entity.
  • David is working on a large-scale data analysis project. What are the three primary characteristics of the data that he must be looking for?
  • Please ensure that you leave yourself enough time to upload your file responses. It is recommended that you upload your file as you complete a file response question.

Create an ERD for the following task

A library keeps records of loans of books to borrowers. Each borrower is identified by a borrower number and each copy of a book by an accession number. The name and address of each borrower are kept so that communications, such as overdue loan reminders, can be sent when necessary. The information required about books is the title, author(s), publisher, publication date, international standard book number (ISBN), purchase price, and current cost, where the purchase price is the price the library paid at the time of purchase, and the current cost is the current replacement cost. For analysis of usage patterns data about old loans is kept for five years.

Are You Searching Answer of this Question? Request Australian Writers to Write a plagiarism Free Copy for You.

Get Help By Expert

Looking for reliable and professional assignment help in Australia? Look no further than Australia Assignment Help! Our team of experienced and highly qualified experts is here to help you with all your academic needs, from essays and assignments to thesis and dissertation writing. You can also get done your assignments at the last moment.