Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a database called LMS for Library Management System using SQL DDL for the with the following scenario: A public library wants to digitize its
Create a database called LMS for Library Management System using SQL DDL for the with the following scenario:
A public library wants to digitize its inventory and member management systems. The library has a variety of books, magazines, and DVDs Each item can be borrowed by a library member under specific borrowing rules. The library needs a database to track these items, the members, and the borrowings.
Below are the requirements for each entity:
Items: Each item in the library be it a book, magazine, or DVD has a title, publication year, and a unique item ID all these attributes are required. Books have authors and ISBNs assume only author per book Magazines have issue numbers and editors assume editor per magazines and DVDs have durations and directors assume director per DVD
Members: Each member of the library has a unique member ID a name, an email address, and a phone number. All mandatory fields
Borrowings: The library needs to track which member borrows what item, including the borrowing date and the return date.
Solution must include the following:
Choose appropriate SQL data types for each column.
Establish relationships between tables using primary keys and foreign keys pair.
SQL Statements for creating tables with appropriate data types and constraints.
Use NULL or NOT NULL appropriately.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started