Tag: Database

French Cuisine – Entity Relationship Diagram (ERD)

french-cuisine

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-logo

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)

network-web-design

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

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)

learn-2-drive

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

SQL Investigation: The Stolen Gemstones

Precious-Gemstones-Exposition

On July the 12th, a hundred prestigious guests were invited to the Precious Gemstones Exposition at the famous Royal Castle, England. This exposition provides a unique opportunity to admire the most precious and valuable gemstones in the world. The gemstones

Relational Databases

Database-Entity-Relationship-Diagram

Tables, Records & Fields A table is a collection of records. Each record is made of fields. Each field has a data type such as String/Text, Integer, Float/Real, Boolean, Date & Time, etc. Primary Keys, Foreign Keys & Relationships The

Learn SQL

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

Need dummy data fo fill in your tables?

GenerateData

Using websites such as www.generatedata.com you can generate large set of dummy data in just a few clicks. You can choose the fields and data types you need and generate a CSV file ready to import into your database or spreadsheet.  

Any Free Alternative to MS Access?

8 of the Challenges listed in the 101 Computing Challenges book require you to use an RDBMS (Relational Database Management Software) which support the creation of multiple objects such as tables, queries, input forms and reports. One of the most