Tag: ERD

The Library – Entity Relationship Diagram (ERD)

Your local library would like you to design a new system to store information about all the books available on the shelves, as well as about the members of the library and the borrowings and reservations they make. The requirements

French Cuisine – Entity Relationship Diagram (ERD)

French Cuisine is a 5-star restaurant serving a selection of carefully selected French recipes in a cosy atmosphere. Their menu is organised into 4 categories as follows: Starters, Main Meals, Deserts & Drinks. In the dining area, there are 21

EasyFlights – Entity Relationship Diagram (ERD)

EasyFlights is an international airline company operating all over the world. As part of a total rollout of all their IT systems, they would like you to suggest the most suitable ERD to be used to design the relational database

web2.0 – Entity Relationship Diagrams (ERD)

Have you ever created a website using HTML, CSS and JavaScript? These three languages are client-side languages which run on your computer through the web-browser and are used to create static websites. HTML is used to add content to a

Rent-A-Bike – Entity Relationship Diagram (ERD)

Rent-a-Bike is a company offering a bike rental service in the London area.​ They would like a new IT system to replace their existing booking system.​ You have been asked to investigate their requirements in order to design the Entity

Driving School – Entity Relationship Diagram (ERD)

Learn2Drive is a driving school that consists of 5 driving instructors. They would like a new IT system that will be used to store information about their instructors, learners, lessons and vehicles used by the instructors. When creating such a

Learn SQL

SQL is a language used to query a database. In other words SQL is used to filter, sort and manipulate data stored in relational databases. By completing the following activities you will learn more about the syntax of SQL and