8002 1002 30/3/2020 528.10 8003 1003 12/4/2020 194.78 8004 1004 23/4/2020 619.44 1. 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 variable length character data up to 30 characters each. The customer balance should support up to six digits on the 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. The invoice amount should support up to 8 digits to the left of the decimal place and two digits to the right of the decimal place. 2. Write the SQL commands necessary to insert the data into the CUSTOMER table and the INVOICE table created in (1).

8002 1002 30/3/2020 528.10 8003 1003 12/4/2020 194.78 8004 1004 23/4/2020 619.44 1. 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 variable length character data up to 30 characters each. The customer balance should support up to six digits on the 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. The invoice amount should support up to 8 digits to the left of the decimal place and two digits to the right of the decimal place. 2. Write the SQL commands necessary to insert the data into the CUSTOMER table and the INVOICE table created in (1).

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

Rent a Car Using Mysqli (procedural or object) Commands (not the pdo): A company wants to record their cars with the followingproperties in order to give chance to the customers to make a search: Cars should be recorded with the following fields.: Car plate(primary key), make, model, car type. (Car types are listed as: mini, economy, luxury, convertible, sports, mini van) You must create 3 forms( 1 html for menu and 2 self-calling phpfiles) and a mysql table (which has the above fields). 1. Menu as html which will have link to other files. 2. A Form to add a new car into db table. (Hint: car type mustbe drop down list based on the types listed above. Plate shouldprimary key.) 3. A form to search a car. Search could be made via using any of the following threecriterias: i. Based on plate ii. Based on Make iii. Based on car type
Q1 ): You are about to design a university database to keep information about departments, professors, and course offerings. Here is what you have been told about this application. Departments are identified by a code (e.g. CSE) and have a name (e.g., "Computer Science and Engineering"). Professors are identified by their initials (like "MNK1"), they have a name, and they are affiliated with at least one department. Professors are either tenured ("tenured" means permanent) or junior (they have to be in one of these categories and they cannot be in both). For tenured professors we want to know the year they earned tenure (year when they became permanent) and for junior professors we want to know the date they were hired. Finally, a department has exactly one chairperson who must be a tenured professor in any department (i.e., there is no requirement that the chairperson is affiliated with the department s/he chairs). A department (e.g., CSE) lists courses to be offered to students for…
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 30 $215 31 60 $195 61 ཙཙ 120 $175 121 and up $155 Click on the datafile logo to reference the data. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 30 $215 31 60 $195 61 120 $175 121 and up $155 172 12
1. Highlight the column G and apply Conditional Formatting that will highlight the price that is above average.
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
Output the information in a formatted table. The title is right justified with a width of 33. Column 1 has a width of 20. Column 2 has a width of 23. Ex: Number of Novels Authored Author name | Number of novels -------------------------------------------- Jane Austen | 6 Charles Dickens | 20 Ernest Hemingway | 9 Jack Kerouac | 22 F. Scott Fitzgerald | 8 Mary Shelley | 7 Charlotte Bronte | 5 Mark Twain | 11 Agatha Christie | 73 Ian Flemming | 14 J.K. Rowling | 14 Stephen King | 54 Oscar Wilde | 1
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2. How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?
a. Create table "STUDENT" with attributes "STUDENT_ID", "STUDENT_NAME", "STUDENT_GPA". 1 b. Use appropriate datatype for each attribute. c. Insert details of three students. Use FOR loop to print these details in the descending order (Highest first and Lowest last) of 2 their GPA.
SQL Use the IN operator to list the item ID and description of each item in category FSH or BRD.
Q.2: Part I: review the customer and agent tables given below, and provide the result of the following relational operators: Draw new tables and give the name of the relational operator: View all customers whose zip code is 32145 View all agents' phone numbers (vertical view) Part II: Review the customer and agent tables given below, and provide the results of performing the three join relational operators shown below (you may create a table for each result or write your answer): Inner join Left join Right join FIGURE Two tables that will be used in join illustrations 3.10 Table name: CUSTOMER Table name: AGENT CUS CODE CUS LNAME CUS ZIP AGENT_CODE 1132445 1217782 1312243 1321242 1542311 AGENT CODE AGENT_PHONE 125 167 231 333 Walker 32145 231 6152439887 32145 125 Adares 6153426778 Rakowski 34129 167 6152431124 Rodriguez 37134 125 9041234445 Smithson 37134 421 1657399 Vanloo 32145 231 SOURCE: Course Technology Cengage Learning