question 3 Part 1:CUSTOMERCUST_NUMCUST_LNAMECUST_FNAMECUST_BALANCE1000BillyJean1050.111001AmandaJohn840.92INVOICEINV DATE23/3/2020INV_NUMCUST_NUMINV_AMOUNT80001000235.898001100123/3/2020312.828002100230/3/2020528.108003100312/4/2020194.788004100423/4/2020619.441. Create both the CUSTOMER and INVOICE tables structure above. Details of both tables are:a) The customer number should store integer values. The name attributes should support variablelength character data up to 30 characters each. The customer balance should support up to six digits onthe left of the decimal place and two digits to the right of the decimal place.b) The invoice number should store integer values. The invoice date should store date values. Theinvoice amount should support up to 8 digits to the left of the decimal place and two digits to the rightof the decimal place.2. Write the SQL commands necessary to insert the data into the CUSTOMER table and the INVOICEtable created in (1). 3. Modify the CUSTOMER table:a) to include the customer's date of birth (CUST_DOB), which should store date data.b) to indicate the date of birth on March 15, 1989 for customer 1000.c) to indicate the date of birth on December 22, 1988 for customer 1001.

Actually, database is a used to stores the data.

3. Modify the CUSTOMER table: a) to include the customer's date of birth (CUST_DOB), which should store date data. b) to indicate the date of birth on March 15, 1989 for customer 1000. c) to indicate the date of birth on December 22, 1988 for customer 1001.

3. Modify the CUSTOMER table: a) to include the customer's date of birth (CUST_DOB), which should store date data. b) to indicate the date of birth on March 15, 1989 for customer 1000. c) to indicate the date of birth on December 22, 1988 for customer 1001.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

The solutions provided didn't work for any of the questions. Please provide different solutions for the 3 questions
Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To decrease the postal costs, they will send gifts to owners in batches to their corresponding offices. Similarly, the marketing team will send the gifts in groups to the residents living in the same property. Therefore, you will need to provide them the number of gifts for each StayWell office and number of gifts for each property. The column headers for the first table should be OFFICE_NUM and GIFTS, the column headers for the second table should be PROPERTY_ID and GIFTS.
Determine which categories are covered by the existing book stock. There should only be one listing for each category.
Determine which types of books are currently available in the current inventory. Each category should only be included once.
For each customer, list the CustomerID and the total number of orders placed in 2015.
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
What is the name of the columns of thee left hand side of the relationships between columns called?
Query: List the IDs of the tutors who are currently tutoring more than one student
question 2 and 3 are not answered.!
What city does Mark Dean reside in?
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
How many homes/apartments/etc. are in your masm etymology?