Create a new table named CUSTOMER_STATUS.The table will hold the Customer_Status_Id and the Customer_Status_Description with possible...

Create a new table named CUSTOMER_STATUS.The table will hold the Customer_Status_Id and the Customer_Status_Description with possible values:

Inactive, Active, Very_Active

These values will be used to characterize the customers so that:

Inactive Customers => Have 0 orders

Active Customers => Have between 1 and 3 orders

Very Active Customers => Have 4 or more orders

Expert Solution

ANS: Tables can be created by using CREATE table tablename .

Inside which the required attributes can be added.

Values to the attributes can be added by using INSERT into the TABLE values( );

The below screenshot shows the creation of table CUSTOMER_STATUS with required attributes and values:

venereology answered 1 year ago

Java program Create a public method named saveData for a class named Signal that will hold...

Java program Create a public method named saveData for a class named Signal that will hold digitized acceleration data. Signal has the following field declarations private double timeStep; // time between each data point int numberOfPoints; // number of data samples in array double [] acceleration = new double [1000]; // acceleration data double [] velocity = new double [1000]; // calculated velocity data double [] displacement = new double [1000]; // calculated disp...

c++ Create a class named EvolutionTree which will hold a list of species and their expected...

c++ Create a class named EvolutionTree which will hold a list of species and their expected age, and allow a user to search for a particular species or an age. EvolutionTree should have private data members: species (a string array of size 400 with all the species) speciesAges (an int array of size 400 for all the species' ages). EvolutionTree should have a default constructor which should initialize the species array to empty strings ("") and initialize the speciesAges array...

Create a class named CollegeCourse that includes data fields that hold the department (for example, ENG),...

Create a class named CollegeCourse that includes data fields that hold the department (for example, ENG), the course number (for example, 101), the credits (for example, 3), and the fee for the course (for example, $360). All of the fields are required as arguments to the constructor, except for the fee, which is calculated at $120 per credit hour. Include a display() method that displays the course data. Create a subclass named LabCourse that adds $50 to the course fee....

Java program Create a constructor for a class named Signal that will hold digitized acceleration data....

Java program Create a constructor for a class named Signal that will hold digitized acceleration data. Signal has the following field declarations private double timeStep; // time between each data point int numberOfPoints; // number of data samples in array double [] acceleration = new double [1000]; // acceleration data double [] velocity = new double [1000]; // calculated velocity data double [] displacement = new double [1000]; // calculated disp data The constructor...

Create a Python Module named piphash_rainbow.py that Creates a rainbow table named sixdigithash_rainbow.csv that stores all...

Create a Python Module named piphash_rainbow.py that Creates a rainbow table named sixdigithash_rainbow.csv that stores all possible six-digit pins and their corresponding md5, sha1, sha256, and sha512 hashes.

Create a class named Lease with fields that hold an apartment tenant’s name, apartment number, monthly...

Create a class named Lease with fields that hold an apartment tenant’s name, apartment number, monthly rent amount, and term of the lease in months. Include a constructor that initializes the name to “XXX”, the apartment number to 0, the rent to 1000, and the term to 12. Also include methods to get and set each of the fields. Include a nonstatic method named addPetFee() that adds $10 to the monthly rent value and calls a static method named explainPetPolicy()...

1. Write the statements to create a table named REQUIREMENTS. The table has the following columns:...

1. Write the statements to create a table named REQUIREMENTS. The table has the following columns: credits number (primary key) and degree name. 2. Write the statements to create a table named CANDIDATE with the following columns names. Pick the best column type: student_id, first name, last name, credits and graduation date. The credits column is a foreign key to the credits column in the REQUIREMENTS table. 3. Write the statement(s) to Insert 2 rows in your REQUIREMENTS table. Make...

Create a new Java project named Program 4 Three Dimensional Shapes. In this project, create a...

Create a new Java project named Program 4 Three Dimensional Shapes. In this project, create a package named threeDimensional and put all 3 of the classes discussed below in this package Include a header comment to EACH OF your files, as indicated in your instructions. Here's a link describing the header. Note that headers are not meant to be in Javadoc format. Note that Javadoc is a huge part of your grade for this assignment. Javadoc requires that every class,...

Create a new Java project named Program 4 Three Dimensional Shapes. In this project, create a...

Create a new Java project named Program 4 Three Dimensional Shapes. In this project, create a package named threeDimensional and put all 3 of the classes discussed below in this package Include a header comment to EACH OF your files, as indicated in your instructions. Here's a link describing the header. Note that headers are not meant to be in Javadoc format. Note that Javadoc is a huge part of your grade for this assignment. Javadoc requires that every class,...

Create a Java project called Lab3B and a class named Lab3B. Create a second new class...

Create a Java project called Lab3B and a class named Lab3B. Create a second new class named Book. In the Book class: Add the following private instance variables: title (String) author (String) rating (int) Add a constructor that receives 3 parameters (one for each instance variable) and sets each instance variable equal to the corresponding variable. Add a second constructor that receives only 2 String parameters, inTitle and inAuthor. This constructor should only assign input parameter values to title and...

Question

Create a new table named CUSTOMER_STATUS.The table will hold the Customer_Status_Id and the Customer_Status_Description with possible...

Solutions

Expert Solution

Related Solutions

Java program Create a public method named saveData for a class named Signal that will hold...

c++ Create a class named EvolutionTree which will hold a list of species and their expected...

Create a class named CollegeCourse that includes data fields that hold the department (for example, ENG),...

Java program Create a constructor for a class named Signal that will hold digitized acceleration data....

Create a Python Module named piphash_rainbow.py that Creates a rainbow table named sixdigithash_rainbow.csv that stores all...

Create a class named Lease with fields that hold an apartment tenant’s name, apartment number, monthly...

1. Write the statements to create a table named REQUIREMENTS. The table has the following columns:...

Create a new Java project named Program 4 Three Dimensional Shapes. In this project, create a...

Create a new Java project named Program 4 Three Dimensional Shapes. In this project, create a...

Create a Java project called Lab3B and a class named Lab3B. Create a second new class...