Customer_ID Customer_Name Order_ID Order_Date Product_Name Quantity 101 Alice 1 2023-09-01 Laptop 2 101 Alice 1 2023-09-01 Mouse 1 102 Bob 2 2023-09-02 Monitor 1 102 Bob 2 2023-09-02 Keyboard 1 103 Carol 3 2023-09-03 Laptop 1 103 Carol 3 2023-09-03 Speaker 2     For the following tables, identify the following functional dependencies where ( ? → Customer_Name).   (Customer_ID → Customer_Name ).   (Customer_ID, Order_ID → Customer_Name ).   (Customer_ID, Order_ID, Order_Date → Customer_Name ).   (Order_ID → Customer_Name ).

Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram:   The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…

Q1:Draw ERD for the following database (Library) Customer Card number Password Name | Address ID Phone Username number Employee ID Phone number Password Username Name Branch number Card Number CW Branch Number Address | Phone number Bill Customer id Employee id Total price Order ID Day Time Book Isbh Name Availability Id Cost Address Cart Order number Book id Customer id Card number Customer Total price name

Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…

10A-

Models Airlines Fleet AID MID Acount manufacturer model capacity Boeing Воeing Вoeing MID AID name 1 777 340 1 American Airlines 1 3 15 2 787 260 United Airlines 1 2 10 3 737 140 Delta Air Lines 2 2 14 4 Airbus 320 230 4 Southwest Airlines 1 Airbus 380 560 5 Alaska Airlines 3. 6. 24 9. Boeing 747 420 3 4 9 5 2 7 3 16 4. Using the above instances of the relational tables Models, Airlines and Fleets, determine whether the following functional dependencies hold. (Write yes/no) 10 ) manufacturer - model Answer: ii) MID – capacity Answer: ii) model → capacity Answer: iv) MID - Acount Answer: v) AID, MID → Accunt Answer:

Write the appropriate SQL DDL statements to declare the relational libraryDatabase. Diagram of Figure 4.6. Select the keys and reference actions that are triggered.

Given the database schema below, write a relational algebra expression to get the count of records in the DEPENDENT relation group by Essn. Also, show the result of your query.

convert it to relations that are normalization

The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…