Tag: Entity Relationship Diagram

The Library – Entity Relationship Diagram (ERD)

Posted on by Administrator Posted in Computer Science, Computing Concepts, Database Concepts, Solved Challenges

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…

Read more ›

French Cuisine – Entity Relationship Diagram (ERD)

Posted on by Administrator Posted in A Level Concepts, Computer Science, Computing Concepts, Database Concepts, Solved Challenges

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…

Read more ›

EasyFlights – Entity Relationship Diagram (ERD)

Posted on by Administrator Posted in A Level Concepts, Computer Science, Computing Concepts, Database Concepts, Solved Challenges

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…

Read more ›

web2.0 – Entity Relationship Diagrams (ERD)

Posted on by Administrator Posted in A Level Concepts, Computer Science, Computing Concepts, Database Concepts

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…

Read more ›

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

Posted on by Administrator Posted in A Level Concepts, A Level Quiz, Computer Science, Computing Concepts, Database Concepts, Solved Challenges

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…

Read more ›

Driving School – Entity Relationship Diagram (ERD)

Posted on by Administrator Posted in A Level Concepts, A Level Quiz, Computer Science, Computing Concepts, Database Concepts, Solved Challenges

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…

Read more ›

Learn SQL

Posted on by Administrator Posted in A Level Concepts, Computer Science, Computing Concepts, Database Concepts, 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…

Read more ›