Lab #1: Single entity modeling lab

1. Draw an ER data model in Lucichart for the following scenarios and map it to relational data model. Make sure to specify a unique identifier.
   1. Draw a data model of a STUDENT entity with proper attributes. The model should allow the user to collect and retrieve data to answer questions like: how many students are female, how many students are of a certain age, and how students vary in terms of grade level.
   2. Draw a data model of an AIRCRAFT. An aircraft has a manufacturer, model number, call sign (e.g., N123D, which is unique for an aircraft), payload, and a year of construction. Aircraft are classified as civilian or military.
   3. Draw a data model of a RESTAURANT. A restaurant has an address, seating capacity, phone number, and style of food (e.g., French, Russian, Chinese).
2. Copy your data models from Lucidchart to a word document and write down the relational data model.