Construct a fish store database where:

Create a java database

Perform the subtraction with the following unsigned binary numbers by taking the 2ʹs complement of the subtrahend, a. 11010 − 10000   b. 11010 − 1101   c. 100 − 110000

CSC 472 Introduction to Database Systems Project Consider the hashing approach for computing aggregations. If the size of the hash table is too large to fit in memory, then the DBMS has to spill it to disk. During the Partition phase, a hash function h1 is used to split tuples into partitions on disk based on targethash key. During the ReHash phase, the DBMS can store pairs of the form (GroupByKey -> RunningValue) to computethe aggregation. Which of the following is FALSE ? Group of answer choices The Partition phase will put all tuples that match (using h1) into the same partition. To insert a new tuple into the hash table, a new (GroupByKey -> RunningValue) pair is inserted if it finds a matching GroupByKey. A second hash function (e.g., h2) is used in the ReHash phase. The RunningValue could be updated during the ReHash phase.

Please help me with this question ERD diagram.

When dealing with dynamic data, it is essential to provide an explanation of how the heap operates. What characteristics of dynamic data make them more desirable to programmers than static data?

Consider a basic database that stores information about students' grades. Create a database and offer a SQL query that returns a list of honour roll students (top 10%), ordered by grade point average.

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…