Use Microst Visio to Construct a Crow's Foot ERD for each scenario in the attached file. Your diagrams should have all the entities, attributes, and relationships and be labeled appropriately. Turn in a single PDF or Word document with all your diagrams. Do not turn in files from Visio or any other modeling software.

Assignment #$2$

Problem $1$: Library Management System

Design an ERD for a library management system that keeps track of books, members, and

borrow transactions. Each book has a title, author, and ISBN. Members have a unique ID$,$ name,

and contact information. Each borrow transaction records the member who borrowed the

book, the book borrowed, and the borrow and return dates.

Problem $2$: University Database

Create an ERD for a university database that stores information about departments, courses,

professors, and students. Departments offer courses, professors teach courses, and students

enroll in courses. Each department has a name and a unique department ID$.$ Courses have a

course ID$,$ name, and the number of credits. Professors have a unique professor ID$,$ name, and

department affiliation. Students have a student ID$,$ name, and major.

Problem $3$: Online Retail Store

Design an ERD for an online retail store that sells products to customers. Each product has a

product ID$,$ name, description, and price. Customers have a customer ID$,$ name, and address.

The store records orders placed by customers, where each order includes the customer who

placed it$,$ the date, and the list of products purchased with their quantities.

Problem $4$: Hospital Management System

Create an ERD for a hospital management system that tracks patients, doctors, treatments, and

appointments. Patients have a patient ID$,$ name, and contact information. Doctors have a

doctor ID$,$ name, and specialty. Each treatment is associated with a doctor and a patient, and

has a treatment ID$,$ description, and date. Appointments are scheduled between patients and

doctors, and include the appointment date and time.

Problem $5$: Music Streaming Service

Design an ERD for a music streaming service that manages users, playlists, songs, and artists.

Each user has a user ID$,$ name, and email. Playlists are created by users and contain multiple

songs. Songs have a song ID$,$ title, duration, and are performed by an artist. Artists have an

artist ID and name. The ERD should capture the relationships between users, playlists, songs,

and artists. Use microsoft Visio to Construct a Crow's Foot ERD for each scenario in the attached file. Your diagrams should have all the entities, attributes, and relationships and be labeled appropriately. Turn in a single PDF or Word document with all your diagrams. Do not turn in files from Visio or any other modeling software.

Assignment #$2$

Problem $1$: Library Management System

Design an ERD for a library management system that keeps track of books, members, and

borrow transactions. Each book has a title, author, and ISBN. Members have a unique ID$,$ name,

and contact information. Each borrow transaction records the member who borrowed the

book, the book borrowed, and the borrow and return dates.

Problem $2$: University Database

Create an ERD for a university database that stores information about departments, courses,

professors, and students. Departments offer courses, professors teach courses, and students

enroll in courses. Each department has a name and a unique department ID$.$ Courses have a

course ID$,$ name, and the number of credits. Professors have a unique professor ID$,$ name, and

department affiliation. Students have a student ID$,$ name, and major.

Problem $3$: Online Retail Store

Design an ERD for an online retail store that sells products to customers. Each product has a

product ID$,$ name, description, and price. Customers have a customer ID$,$ name, and address.

The store records orders placed by customers, where each order includes the customer who

placed it$,$ the date, and the list of products purchased with their quantities.

Problem $4$: Hospital Management System

Create an ERD for a hospital management system that tracks patients, doctors, treatments, and

appointments. Patients have a patient ID$,$ name, and contact information. Doctors have a

doctor ID$,$ name, and specialty. Each treatment is associated with a doctor and a patient, and

has a treatment ID$,$ description, and date. Appointments are scheduled between patients and

doctors, and include the appointment date and time.

Problem $5$: Music Streaming Service

Design an ERD for a music streaming service that manages users, playlists, songs, and artists.

Each user has a user ID$,$ name, and email. Playlists are created by users and contain multiple

songs. Songs have a song ID$,$ title, duration, and are performed by an artist. Artists have an

artist ID and name. The ERD should capture the relationships between users, playlists, songs,

and artists.