One Pager Cheat Sheet

• You should create projects that demonstrate your ability to use SQL and create complex database schemas in order to prove your knowledge and skills and get the most out of your practice.
• This project creates a database of college or school data, capturing pertinent info for Students and Teachers, as well as course data, and enables querying of this data to access useful information.
• This database can be used to store details about bicycles, users and rentals, and to query for example about bikes rented in the past 3 days or bikes rented from one location and returned to another.
• This hospital management database project can allow you to query records and data of patients, doctors, and rooms, as well as have modules and data for hospital departments, specialist doctors, treatments, etc.
• This project is a simple database that holds information related to Comic entities, including Comic name, year, category, character Id, date of purchase, and gifted by properties, and can be used to answer queries such as Find all the Superman comics released in 1998 and Find all the Batman comics gifted by Anne.
• A database should be created to record user data and product data such as specs, name, color, brand, and price to allow queries to be made for products such as Samsung phones under $799 and phones with 6-inch screens released after 2019, as illustrated in the ER diagram.