VI. LABORATORY ACTIVITY 1. Create an anonymous block with the following specifications: a. In the declarative section, declare the following variables: i. variable vtoday of type DATE. Initialize today with SYSDATE. i. variable v tomorrow, of type today. Use %TYPE attribute to declare this variable. b. In the executable section, initialize the tomorrow variable with an expression, which calculates tomorrow's date (add one to the value in today). Print the value of today and tomorrow after printing "Hello World." c. Execute and save this script as lab_02_01_soln.sql. Sample output is as follows: anonymous block completed Hello World TODAY IS : 16-MAY-07 TOMORROW IS : 17-MAY-07

VI. LABORATORY ACTIVITY 1. Create an anonymous block with the following specifications: a. In the declarative section, declare the following variables: i. variable vtoday of type DATE. Initialize today with SYSDATE. i. variable v tomorrow, of type today. Use %TYPE attribute to declare this variable. b. In the executable section, initialize the tomorrow variable with an expression, which calculates tomorrow's date (add one to the value in today). Print the value of today and tomorrow after printing "Hello World." c. Execute and save this script as lab_02_01_soln.sql. Sample output is as follows: anonymous block completed Hello World TODAY IS : 16-MAY-07 TOMORROW IS : 17-MAY-07

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

For this quest, you are going to start with the Attribute and Monster structs from the previous quest and write several functions (NOTE: I've renamed the Monster struct to Object). You will have to decide the return type and parameters! 1. printType(); a. will use a switch to print to the console an object's type. 2. loadGame() a, this function will load a saved game from a file. b. The file is structured such that the first item in the file is the number of objects. c. Each object in the file starts with the integer value for the Object::Type enum followed by values for all the attributes. 3. saveGame() a. This function is called when a player quits the game in the middle of a battle. b. The number of monsters +1 is first output to the file c. Each object (starting with the player) has the integer value of their name output followed by all the object's attributes. 4. displayBattle(); a. outputs to the console the player's information and a numbered list of monsters along with their…
INSTRUCTIONS: Write a C++ script/code to do the given problem. Write a class called profileID, which has data members firstName,lastName, age, birthday and ageCompany (the age when you entered in the company). Remember to use set and get methods to access the data members this time. Also, write another class called bonusAward that has a method getBonus()with arguments yos and etype which are both integer data types. This method calculates the bonus received by an employee using this formula: yos*1000 + etype*1000. Write two derived classes, ASE and SE, using multiple inheritance usingprofileID and bonusAward as parent classes. Both classes must have amethod named getyos()that returns the yos of an employee using the formula age–ageCompany; and a method named getetype() which returns a constant based on the employee type. For ASE, the constant is 10 while for SE that constant is 20. Last, write a main program where you instantiate ASE as employee1 and SE as employee2. Get their…
Please provide JAVA source code for following assignment. Please attach proper comments and read the full requirements. The local Driver’s License Office has asked you to write a program that grades the written portion of the driver’s license test The test has 20 multiple choice questions. Here are the correct answers: B D A A C A B A C D B C D A D C C D D A A student must correctly answer 15 of the 20 questions to pass the exam. Write a class named Drivertest that holds the correct answers to the test in an array field. The class should also have an array field that holds the student’s answers. The class should have the following methods: passed. Returns true if the student passed the test, or false if the student failed totalCorrect. Returns the total number of correctly answered questions totalIncorrect. Returns the total number of incorrectly answered questions questionsMissed. An int array containing the…
You are part of a team writing a system which keeps track of envelopes people sendthrough the postal system. The process begins when a person gives the envelope to apost office, at which point a barcode (containing all necessary information) is generated,and the envelope is labelled. Then, it is possible to keep track of the envelope betweendifferent cities/offices. The software has the following functions:i. generateBarcode()ii. createDatabaseRecord()iii. updateDatabaseRecord()iv. decodeBarcodeAndUpdateEnvelopPosition()v. getEnvelopPosition() (a) State and describe TWO types of beneficial module couplings that may be present inthis piece of software. (b) For each function, pick an example of possible module cohesion and explain the typeof that module cohesion. (c) We know that function updateDatabaseRecord() alters the actions of functioncreateDatabaseRecord(). State and describe the type of module coupling that exists inthe code containing these two functions.
Please submit a flowchart of your program for your project below. Need a class which will contain: Student Name Student Id Student Grades (an array of 3 grades) A constructor that clears the student data (use -1 for unset grades) Get functions for items a, b, and c, average, and letter grade Set functions for items a, n, and c Note that the get and set functions for Student grades need an argument for the grade index. Need another class which will contain: An Array of Students (1 above) A count of number of students in use You need to create a menu interface that allows you to: Add new students Enter test grades Display all the students with their names, ids, test grades, average, and letter grade Exit the program Add comments and use proper indentation. Nice Features: I would like that system to accept a student with no grades, then later add one or more grades, and when all grades are entered, calculate the final average or grade. I would like the system to display the…
Which of the following statements is false?a. An example of an attribute is the _intMinutes variable in a Time class.b. An example of a behavior is the SetTime method in a Time class.c. A class is considered an object.d. An object created from a class is referred to as an instance of the class.
Program Specifications Write a FancyCar class to support basic operations such as drive, add gas, honk horn and start engine. fancy_car.py is provided with function stubs. Follow each step to gradually complete all instance methods. Note: This program is designed for incremental development. Complete each step and submit for grading before starting the next step. Only a portion of tests pass after each step but confirm progress. The main program includes basic calls to the instance methods. Add statements in the main program as instance methods are completed to support development mode testing. **Step 0: Complete the constructor to initialize the model and miles per gallon (MPG) with the values of the parameters. Initialize the odometer to five miles and the tank to be full of gas. By default, the model is initialized to "Old Clunker", and MPG is initialized to 24.0. Note the provided constant variable indicates the gas tank capacity of 14.0 gallons. Step 1 Complete the instance…
In this lab, you create a derived class from a base class, and then use the derived class in a C++ program. The program should create two Motorcycle objects, and then set the Motorcycle’s speed, accelerate the Motorcycle object, and check its sidecar status. Instructions Ensure the file named Motorcycle.cpp is open in your editor. Create the Motorcycle class by deriving it from the Vehicle class. Use a public derivation. In the Motorcycle class, create a private attribute named sidecar. The sidecar attribute should be data type bool. Write a public set method to set the value for sidecar. Write a public get method to retrieve the value of sidecar. Write a public accelerate() method. This method overrides the accelerate() method inherited from the Vehicle class. Change the message in the accelerate() method so the following is displayed when the Motorcycle tries to accelerate beyond its maximum speed: "This motorcycle cannot go that fast". Open the file named…
In this lab, you create a derived class from a base class, and then use the derived class in a C++ program. The program should create two Motorcycle objects, and then set the Motorcycle’s speed, accelerate the Motorcycle object, and check its sidecar status. Instructions Ensure the file named Motorcycle.cpp is open in your editor. Create the Motorcycle class by deriving it from the Vehicle class. Use a public derivation. In the Motorcycle class, create a private attribute named sidecar. The sidecar attribute should be data type bool. Write a public set method to set the value for sidecar. Write a public get method to retrieve the value of sidecar. Write a public accelerate() method. This method overrides the accelerate() method inherited from the Vehicle class. Change the message in the accelerate() method so the following is displayed when the Motorcycle tries to accelerate beyond its maximum speed: "This motorcycle cannot go that fast". Open the file named…
Create the following methods for the class MyArray Submit Main.cpp, (others files if you decide to write your code using *.cpp and *.h) and a ReadMe.pdf file with screen result screenshot of each function. Address all the function calls in the "int main" in same order of of the following. provide specific instructions for the user for the inputs. (ex: Please enter an element to find : ) Methods to Implement Default Constructor for the class Constructor with array size (user input the size) Destructor for the class Use random function to store values (ex: store 1000 numbers between 1 and 10000 range) Function to access the size Display the content of the array (Display contents as a table of 10 columns with contents left aligned) Function to Add an element at the beginning Function to Add an element at the end Function to Remove an element at the beginning Function to Remove an element at the end Function to Inverse the order of the elements in the array (perform this function after…
Often times after a big meal, we may find ourselves considering how much we need to exercise to work off what we just ate. In this exercise we will actually compute it. 1) Oxygen consumption (VO2) can be used as an indicator of exercise intensity, which is closely tied to energy expenditure. In other words, VO2 can be used to approximate how many calories are burned during an activity. The approximate VO2 for walking (on flat land) at a given speed (mph) can be computed as: VO, for walking = 2.68224 x speed + 3.5 The approximate VO, for running (on flat land) at a given speed (mph) can be computed as: VO, for running = 5.36448 x speed + 3.5 2) The calorie burn rate (CBR) is the number of calories burned per minute when doing a certain activity. A simplified way to compute the CBR from VO, and a person's weight (Ibs) is given by the formula: CBR = (2.268 x 10) x VO2 x weight %3D You need to write three (3) versions of a program that calculates how many minutes one needs to exercise to…
I have two codes. One is validator and another is main code. Please make the main code follow requirement of validator like assertation. requirenment. Validator:--------- @points(5)def test_flour_sack():"""Testing flour_sack"""module = import_file("pizza.py")_test_ingredient(module.flour_sack, "flour") @points(5)def test_yeast_jar():"""Testing yeast_jar"""module = import_file("pizza.py")_test_ingredient(module.yeast_jar, "yeast") @points(5)def test_salt_shaker():"""Testing salt_shaker"""module = import_file("pizza.py")_test_ingredient(module.salt_shaker, "salt") Main code:------ from time import time def flour_sack(capacity=10):for i in range(capacity):yield 'flour ' def yeast_jar(capacity=20):for i in range(capacity):yield 'yeast ' def salt_shaker(capacity=100):for i in range(capacity):yield 'salt ' def water_faucet():while True:yield 'water' if __name__ == "__main__":pass