Create an Entity Diagram and write a database design outline for the following:

Question 2. (20 points) Your firm maintains gated parking lots, cach with its own code ("Yellow" or "Red" for cxample), number of spaces, and description (example: "behind main manufacturing facility"). Each employee has regular permission to park in exactly one parking lot. For each employee, you want to store a first name, middle name/initial, last name, home address information, date hired, office phone number, and cell phone number. Each employee may own one or more vehicles, and has permission to park any of these vehicles in his or her designated lot. Assume that one vehicle cannot be owned by multiple employees. For each vehicle, you want to store the license plate number, the state in which vehicle is registered (using standard two-letter codes), the make, model, year, and color. Omestion 3.30 points) You operate the PC computer support group for a medium-sized company. You wish to keep records of the time your group spends servicing various personal computers within the firm. Each company-owned PC is identified by a unique property tag number; in addition, you want to record the PC's make and model, the room number where it is located, and the date it was acquired. Each computer "belongs to a department of the company, identified by a department code. Each department also has a name. Some departments have only a few computers, but some have as many as a hundred. Every time one of your technicians services a computer, you want to record which computer was serviced, which technician performed the service, the date/time the service started, the date/time it ended, and a description of the work performed. Each technician is identified by an employee ID number, for each technician, you also want to store their first name, middle name/initial, last name, and date hired. Question 4. (30 points) You are in charge of keeping track of Rutgers bus system. You operate a number of different kind of bus, for example, "LX" or "REXL." For each kind of bus, you want to keep track of the operating hours and days of operations. For example, "A" bus operates from 7:00 AM until 9:30 PM during the weekdays and "H" bus operates from 6:00 AM until 2:30 AM during the weekdays. For each bus, you want to store bus ID, date acquired, maximum mileage. Each kind of bus uses multiple buses, but, for simplicity, assume one bus can be used in exactly one kind of bus. If a bus 12255039 is "LX"bus, then the bus will be "LX" until it reaches the maximum mileage. The event of a bus leaving the first station is called a dispatch. Every time a bus dispatches, you want to record which bus was dispatched, who was the driver, the date/time the dispatch started, the date/time the dispatch ended, and up to 255 characters of text for driver comment (such as "back door is not working"). Each driver has a unique employee ID, along with a first name, last name, middle name, date of birth, cell phone number, and date of last safety training