- Explain that an Entity Relationship Diagram is used to visualise and define the implementation of a database
- Use user stories to design conceptual data models
- Use conceptual data models to design logical data models
- Use logical data models to design physical data models
Fork the repo as normal.
Create the Entity-Relationship Diagrams using whichever tool you feel works best for you.
Once you have a solution for each activity add it to this repo as an image.
Push your repo once you have completed the activities and create a Pull Request as normal.
”A local hotel wants to keep a record of room bookings. The hotel has a lot of rooms, but customers will only be able to choose one room per booking. The person who books the room is not necessarily the person providing contact details.”
- As a customer, so I can have a place to stay tomorrow night, I want to book a room at the hotel.
- As the hotel owner, so I can expand my business, I want to add new rooms to the hotel.
Design a simplified booking system for this epic.
Come up with User Stories (and possibly a more detailed Epic) for each of the following scenarios.
Then design the database tables and relationships which would be needed to implement them.
-
A local candle maker wants to open an online store selling their handmade candles and other artifacts, they need a database system to use as part of this online shop. Details of customers need to be stored, products need to be stored and updated, a record of customer orders also needs to be maintained. Design the database system for the Candle Shop.
-
A restaurant wants to introduce an online booking system for their main dining room, which has various tables. The restaurant is open throughout the day so customers can book for a variety of times.
-
A University library wishes to implement an online system for borrowing books and other items from the library. Each user will be able to borrow up to 6 items at a time.
-
When they originally launched Social Media sites such as Twitter, Identica, Diaspora and Mastodon all described themselves as micro-blogging sites, design a database schema for a similar micro-blogging Social Media site.
-
Think about an online learning system as used by a school, a university or a coding bootcamp, design the database tables etc that might be required to implement such a system.