$1-$You are tasked with designing a conceptual model for a hotel reservation system. What entities

and relationships should you include?

$2-$A travel agency is looking to create a logical model to manage flights, customers, and bookings.

What key aspects should they focus on$?$

$3-$A social media platform needs to manage user profiles, posts, and comments. What database

type would you recommend?

$4-$An organization requires a database to handle both structured and unstructured data, such as

emails and documents. What type of database would be suitable?

$5-$A restaurant wants to track menu items, orders, and customers. What would be important to

include in the conceptual model?

$6-$A university wants to build a system for tracking student courses, grades, and instructors. What

key considerations should be included in the logical model?

$7-$An online store wants to implement a recommendation system based on user behavior. What

type of database would facilitate this?

$8-$You are designing a data model for a sports league management system. What entities andYou are designing a data model for a sports league management system. What entities and

relationships would you include?

$9-$A company is transitioning to a microservices architecture and needs a database that can easily

scale. What type of database should they consider?

$10-$A logistics company requires a system to track shipments, delivery status, and customer

information. What elements should be included in the conceptual model?

Derive the potential business rules from each situation

$11-$A Essex county college library system tracks borrowed books. Each member can borrow up to

five books at a time, and they must return books within two weeks.

Question : What business rules can be derived from this?

$12-$An online marketplace allows sellers to list products. Sellers must provide a description, a price,

and at least one image for each product listing.

Question : What business rules should be established based on this requirement?

$13-$A George Effah'travel agency manages customer bookings. Customers can change their travel

dates up to $48$ hours before departure but must pay a fee for changes made less than $48$ hours

before the trip.

Question : What business rules can be applied here?

$14-$A subscription service allows users to subscribe to multiple plans but only permits one active

subscription at a time. Users can switch plans at the end of their billing cycle.

Question : What business rules should govern this?

$15-$A restaurant requires that customers provide their dietary preferences when making

reservations. If a customer's preference is not met, they are entitled to a discount on their meal.

Question : What business rules can be derived from this requirement?

relationships would you include?

$16-$A company is transitioning to a microservices architecture and needs a database that can easily

scale. What type of database should they consider?