The three-layer architecture has the primary objective of separating each user’s view of the database from the way it is physically represented. Using an example database architecture of your own, answer the following questions:   Provide an example of a structure at each of the three-levels  Using the answer from a) above, describe physical data independence

A taxi company would like to provide an online service for customers to book a trip and for taxi drivers to check their upcoming trips. A database needs to be created to store customer data (name, address, email, telephone number) and trip information (pick up and drop off address and pick up time and date). Furthermore, your database should contain driver information (name and license plate). Each trip must be assigned to exactly one driver (and trips for a driver must not overlap). Customers who are not registered yet need to register (providing their address, phone number, email address, and credit card information). A registered customer should be able to book a trip, i.e. provide the pick-up address and time as well as the drop-off address via a graphical user interface. Customers should also be able to view their trips and cancel them if needed. All these operations are only possible after a customer signs in (which means they must be registered). Each new trip must be confirmed…

Explain the purpose of the First Normal Form (1NF) and provide an example of a database that meets this requirement.

What makes entity relationship (ER) diagrams crucial for database architecture, in your opinion?