Table_ratingtable menutable_menu_typetable_usermenu_type_IDrating IDmenu IDuser_IDplaced• type_name• description# menu_ID• remarks• data_recorded: date# customer ID• menu_name# price#menu_type ID• menu imageingredients#menu_status• full_name• contact• email address* username• passwordassignedrepresenttable_paymentpayment_ID4 order IDC# amountpaid_by-payment_date# processed_by| assignedtotable_customercustomer_ID• Customer_first_name• customer_last_name• customer_middle_name• customer_email• customer_phone_number• customer_landline• profile_image• customer_usemame• customer passwordtable_order_detailsI Jorder_details_IDincludeI l order_ID# menu_ID# amount# no of serving# total_amounttable_site_info# account_statussite_info_IDL• site_name• description• contact_info* address• last_updateHuser_IDtable_orderpart ofplacedby# customer_ID-order_date#total_amountWorder_status#processed_bypaysordersCustomersPK customer_ID- customer zip_code_prefix- customer city- customer statePK order_ID- customer ID- order_status- order purchase timestamp DATETIME- order approved at DATETIME- order_delivered_carrier_date DATETIME- order_delivered_customer_date DATETIMEorder estimated_delivery_date DATETIMEmakesorder_itemsorders_order_IDPK order_ID- product_ID- shipping limit date DATETIME- price DECIMALfreight_value DECIMALcontainsorder_items_order_IDpayment order IDproducts product_IDраymentcontainsPK order_IDpayment_sequential-раyment_type- payment_installmentspayment_value DECIMALproductsPK product_ID- product_category_name- product_name_length- product_description_length- product photo_quantityGiven that information ERD and EERD. draw the dependencydiagram INF,2NF and 3NF. Make sure that you label thetransitive and/or partial dependencies.

Answered: Given that information ERD and EERD.…

Given that information ERD and EERD. draw the dependency diagram 1NF,2NF and 3NF. Make sure that you label the transitive and/or partial denendencies

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter6: Additional Database Objects

Section: Chapter Questions

Problem 6HOA: A new table has been requested to support tracking automated emails sent to customers. Create the...

See similar textbooks

Similar questions

student takes ID ID course_id sec_id semester year grade пате dept_name tot_cred section course department course_id sec_id semester year building room_no time_slot_id course_id title dept_name credits advisor dept_name building budget s_id i id time_slot time_slot_id day start_time end_time prereq instructor classroom COurse_id prereg_id ID building пате dept_name salary room_no сараcity teaches ID course_id sec_id semester year Consider the relation that results from the expression: course natural join department Which of the following functional dependencies hold for this relation? (Mark all that apply) O {title, credits} -> building O dept_name -> budget O course_id -> {budget} O {building, budget} -> dept_name O title -> credits O {course_id, title} -> credits
MySql Workbench CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 1. List last name of all students whose first name is longer than 4 letters in ascending order accordingto the last name. Duplicated rows should be removed from the output.2. Count the total number of rooms in Location.3. Find the number of students in each major.4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...
SQL: Add a table-level PRIMARY KEY constraint to the EMPLOYEE table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Create a PRIMARY KEY constraint on the DEPARTMENT table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Add a foreign key reference on the EMPLOYEE table that will ensure that the employee is not assigned to a nonexistent department. Confirm that the constraints were added by querying USER_CONSTRAINTS. Note the types and names of the constraints and include them in your statement comments. Display the object names and types from the USER_OBJECTS data dictionary view for EMPLOYEE and DEPARTMENT tables. You will want to format the columns for readability. Provide comments that include the new tables and indexes created. Modify the EMPLOYEE table by adding a SALARY column of NUMBER data type, precision 7. Confirm…
SERVICE_ID PROPERTY_ID CATEGORY_NUMBER OFFICE_ID DESCRIPTION STATUS EST_HOURS SPENT_HOURS NEXT_SERVICE_DATE 1 11 2 2 The second bedroom upstairs is not heating up at night. Problem has been confirmed. central heating engineer has been scheduled. 2 1 2019-11-01 2 1 4 1 A new strip light is needed for the kitchen. Scheduled 1 0 2019-10-02 3 6 5 1 The bathroom door does not close properly. Service rep has confirmed issue. Scheduled to be refitted. 3 1 2019-11-09 4 2 4 1 New outlet has been requested for the first upstairs bedroom. (There is currently no outlet). Scheduled 1 0 2019-10-02 5 8 3 2 New paint job requested for the common area (lounge). Open 10 0 NULL 6 4 1 1 Shower is dripping when not in use. Problem confirmed. Plumber has been scheduled. 4 2 2019-10-07 7 2 2 1 Heating unit in the entrance smells like it’s burning. Service rep confirmed the issue to be dust in the heating unit. To be cleaned. 1 0 2019-10-09 8 9 1 2 Kitchen sink does not drain properly. Problem…
Normalise the data : Table: Administrator Field Name Data Field Constraints Description size type varchar Admin ID 15 Primary Key Contains the Admin id Admin char 50 Not null Contains the Name Admin name Not null Contains email Email varchar 20 the Address char 10 Not null Contains the address Phone int 8 Not null Contains the Number phone number Table: Product Field Name Data type Field size Constraints Description Product ID varchar 20 Primary Key Contains the product id Product Name char 25 Not null Contains product name Category char 13 Not null Contains the category CustomerlD varchar 15 Foreign key Contains the customer id
Submission guidelines: The assignment must be submitted by the deadline (earlier submissions are encouraged) in PDF format through Blackboard using the following file name format: LastName_FirstName_Assignment_1.pdf. The assignment must be typewritten. All the assignments in this course are individual work; any overlap between assignment reports will be penalized. A bank requires for their customers to access their online banking accounts to provide as User Id (or user name) the last 8 digits of their bank card number, and a password with a length between 8 and 12 ASCII characters, including the following restrictions (posted on their website): Passwords must have at least 8 characters long and at most 12 characters long, and must include at least one character from each of the following four character types: Upper case letters ABC DEF Lower case letters ghijkl Numbers 1 2 345 67890 Special characters ! @ # $ % ^ & * (+) = - The remaining characters of the password must be selected…
Write an SQL query to display: The last name of the student who registered at the last. K Your output should contain 1 column in the below-mentioned order. last_name
A unique identifier for a data row that consists of more than one field is commonly called a: primary plus key composite primary key foreign key none of the above
Perform the following tasks: a. Create an index named ITEM_INDEX1 on the ITEM_NUM column in the ORDER_LINEtable. b. Create an index named ITEM_INDEX2 on the CATEGORY column in the ITEMtable. c. Create an index named ITEM_INDEX3 on the CATEGORY and STOREHOUSE columnsin the ITEM table. d. Create an index named ITEM_INDEX4 on the CATEGORY and STOREHOUSEcolumns in the ITEM table. List categories in descending order.