Question

this is about databases and SQL, please help me with this and i promise i will thumbs you up :) let me know if you need more info please try to get this done i will definitely thumbs you up :))

PROJECT TOPIC: Library: Books, Copies of the books, Patrons, Checkouts

when creating ERD diagram, the notation must be in crows notation, attached at the bottom is an example of crows foot notation in databases so you can understand.

1. PDF file generated from Lucid Chart ( or any way to show diagram in crows foot notation) containing the following information:
   • The name of the project
   • 3-4- sentences describing the problem (Use the topic assigned to your name to define and describe the business situation)
   • List of the business rules (make assumptions if degree of the relationship is not known)
   • ERD of the database (please must be in crows notation also showing PK, FK1, FK, etc..)
2. SQL Notebook in microsoft sql server mangement or azure data studio notebook sql code please

• Text section:
• Code section with execution results
  • Commands to create all the tables
  • Commands populating 5-10 records into each of the table
  • Select commands for each of the tables
  • create TABLE Movie(movieID int primary key, movieName
    varchar(10), dateOfRelease date, budget int);
  • ^^^ sql code should run/look similar to bullet point above :)
  • below is an example of crows foot notation with some other topic but please make sure you are doing the topic listed below...

    PROJECT TOPIC: Library: Books, Copies of the books, Patrons, Checkout

FIGURE 8.1 DATABASE MODEL LINE Hit generates contains INVOICE PK INV_NUMBER FK1 CUS_CODE INV_DATE CUSTOMER PK CUS CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS AREACODE CUS_PHONE CUS_BALANCE PK,FK1 INV_NUMBER PK LINE NUMBER FK2 P_CODE LINE_UNITS LINE_PRICE is found in 1 VENDOR PK V_CODE V_NAME V_AREACODE V_PHONE V_STATE V_ORDER V CONTACT Ho-supplies 0 PRODUCT PK P_CODE P_DESCRIPT P_INDATE P_QOH P_MIN P_PRICE P_DISCOUNT FK1 V_CODE

Answer 1

PROJECT TOPIC: Library: Books, Copies of the books, Patrons, Checkouts

ERD diagram in crows foot notation -

In this ERD i have mentioned total of 7 entities/tables-

1. Library
2. Patrons
3. Books
4. Copies of Books
5. Category
6. Checkout
7. Person

Each of them have a separate attributes and i have also mentioned the data types of each attribute separately.

The relation among eaach table has also been drawn and the keys have also been mentioned, the primery keys as PK and the Foriegn Keys as FK.

Library PK Library ID Number Title Text FK Patrons ID Number Patrons PK Patrons ID Number Name Text contact Number Address Text H + Books PK Books ID Number name Text Author Text Category FK Number ID Language Text FK Library ID Number Checkout FK Number ID 당 Copies of Books PK"copies ID Number OFK Books ID Number No. of Number copies Person PK Person ID Number name Text contact Number O Checkout Checkout PK Number ID Checkout Date Number Days of Number issue FK Book ID Number FK Person ID Number Category PK Category ID Number Name Text

Where as the rest of question, can you please elaborate it by naming each part separately so that i could get an idea how to present the answers.

Feel free to ask any ques, i would like to answer

thank you