Implement, using SQL, a database of at least 3 tables and show how to use the virtual database to protect it

Give each of the following methods for storing a relational database two advantages, two disadvantages, and a summary of how they affect the database as a whole. A separate file should be kept for each relationship.

Explain the concept of distributed database transparency and its various types.

This example might be improved by starting with a database maintained by an airline that employs "snapshot isolation." What if, rather of increasing the airline's overall performance, a non-serializable execution did so?

The preceding examples demonstrate that such connections are impossible in a relational database.

Describe the concept of "lazy loading" in the context of database connectivity.

Suppose a database system is without concurrency control. Describe an example that the concurrency of multiple transactions results in inconsistency in the database. You can take the banking system, ticket booking system or any other database system for example.   Please explain the outer-schema, schema, inner-schema structure of database system.

This kind of interaction is impossible in a relational database, as seen by the preceding instances.

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…

Assume that a database system is installed on a server with 3 core processors. You want your query to run on multiple processors so that each processor accesses in parallel a subset of the database. Or, you might set up your system in a way that partitions your query so that each part of the same query runs on a different processor. Explain, with an example, how a query might be broken apart so that each parallel processor handles a subset of the query