SOLVE THE BELOW PROBLEMS CONSIDERING GIVEN TABLES. PK EMP FK EMPNO ENAME MGR DEPTNO SAL COMMISSION 100 REHAB MANAGER 1236 12 7500 500 101 MAAZ MANAGER 1234 10 so00 300 102 ALI CLERK 135 11 200 104 MAT ARCHITECT 1236 12 so DEPT DEPINO ONAME LOC 10 IT ABHA 11 IS JAZAN 12 CNET RIYADH Problem 1.1: Create a table called EMP with the following structure. Name Iyne EMPNO NUMBER(6) ENAME VARCHAR2(20) JOB VARCHARZ(10) MGR NUMBER(4) DEPTNO NUMBER(3) SAL NUMBER(7,2) Problem 1.2: Add a column COMMISSION which can hold NULL value. Problem 1.3: Modify the column width and data type of the JOB field of EMP1 table.

SOLVE THE BELOW PROBLEMS CONSIDERING GIVEN TABLES. PK EMP FK EMPNO ENAME MGR DEPTNO SAL COMMISSION 100 REHAB MANAGER 1236 12 7500 500 101 MAAZ MANAGER 1234 10 so00 300 102 ALI CLERK 135 11 200 104 MAT ARCHITECT 1236 12 so DEPT DEPINO ONAME LOC 10 IT ABHA 11 IS JAZAN 12 CNET RIYADH Problem 1.1: Create a table called EMP with the following structure. Name Iyne EMPNO NUMBER(6) ENAME VARCHAR2(20) JOB VARCHARZ(10) MGR NUMBER(4) DEPTNO NUMBER(3) SAL NUMBER(7,2) Problem 1.2: Add a column COMMISSION which can hold NULL value. Problem 1.3: Modify the column width and data type of the JOB field of EMP1 table.

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

Create a data type that allows you to insert, remove the maximum, and delete the minimum (all in logarithmic time), as well as locate the maximum and find the minimum (both in constant time). Use two piles as a hint.
Use Python Programming - restaurant reservation program. The application offers different reservation rate for adults and children. (see sample below) RESTAURANT RESERVATION SYSTEMSystem Menua. View all Reservationsb. Make Reservationc. Delete Reservationd. Generate Reporte. Exit 2. When the VIEW RESERVATIONS is clicked, this will display all the reservations made: # Date Time Name Adults Children 1 Nov 10, 2020 10:00 am John Doe 1 1 2 Nov 25, 202011:00 am Michelle Franks 2 1 3 Dec 10, 2020 9:00 am Ella Flich 1 1 4 Dec 21, 2020 12:00 pmDylan Cloze 2 1 3. If the user selects MAKE RESERVATION, the user needs to input the following: a. Name (String)b. Date (String)c. Time (String)d. No of Adults (Integer)e. No of Children (Integer) Note: Adult is 500 per head and Kids is 300 per head reservation, save the data in a text file. 4. If DELETE RESERVATION is selected, the user needs to input the reservation number to remove the existing reservation. 5. If the GENERATE REPORT is clicked,…
Use Python Programming - restaurant reservation program. The application offers different reservation rate for adults and children. (see sample below) RESTAURANT RESERVATION SYSTEMSystem Menua. View all Reservationsb. Make Reservationc. Delete Reservationd. Generate Reporte. Exit 2. When the VIEW RESERVATIONS is clicked, this will display all the reservations made: # Date Time Name Adults Children 1 Nov 10, 2020 10:00 am John Doe 1 1 2 Nov 25, 202011:00 am Michelle Franks 2 1 3 Dec 10, 2020 9:00 am Ella Flich 1 1 4 Dec 21, 2020 12:00 pmDylan Cloze 2 1 3. If the user selects MAKE RESERVATION, the user needs to input the following: a. Name (String)b. Date (String)c. Time (String)d. No of Adults (Integer)e. No of Children (Integer) Note: Adult is 500 per head and Kids is 300 per head reservation, save the data in a text file. 4. If DELETE RESERVATION is selected, the user needs to input the reservation number to remove the existing reservation. 5. If the GENERATE REPORT is clicked,…
Create an anonymous block that displays a course list. Declare a cursor and use the OPEN,FETCH, and CLOSE cursor statements to access the cursor. Use the %ROWTYPE attribute for the cursor.
Hint: Look at the hidden members by typing six.__ then pressing tab. Or use dir(six) to get a list of all the members including hidden members. how do you fill in the following? ->ANSWER_3_1 = ... # FILL ME IN (one line) print(ANSWER_3_1)
Fill in the loop table with the correct values, Each row should represent the values of the variables at the line with the comment LOCATION. You don't necessarily need to fill out all of the rows on the provided fable. If you don't fill up the whole table, that isn't necessarily wrong! 1 - 2 a - 10 name - 'AL' while i < 9: if name 'AL': 1: 2 nam AL intinl else: if name < 'NAPOLEON': name - 'NASH elif name < 'NATE': name - 'SAM' else: name- 'AL ' # LOCATION
Please do completely . Do subquestions 1,2,3,4.thAnks
Assignment Two: We will write three procedures on our tables, the first of which I have provided as an example. proclnsertPlayer takes one IN VARCHAR(16) paramater and returns an error code in the second SMALLINT (INOUT) parameter. The procedure checks the parameter and, if there are no errors, inserts the value into tblPlayers. Documentation of errors Condition Error code No errors 1st param Null or zero len playerID taken 1 proclnsertGame will receive two IN VARCHAR(16) interpreted as
#Fill in comments to spec. import sqlite3from contextlib import closing from Objects import Player, Lineup conn = None def connect():global connif not conn:DB_FILE = "player_db.sqlite"conn = sqlite3.connect(DB_FILE)conn.row_factory = sqlite3.Row def close():if conn:conn.close() def get_players():return None #remove this line when code is added.# SQL statement to select all 7 fields for all players # Use a with statement to execute the query # Create a lineup object# use a loop to populate the lineup object with player objects# return the lineup object def get_player(playerID):return None #remove this line when code is added.# SQL statement to select all 7 fields for a player # Use a with statement to execute the query & return a player object if the player exists def add_player(player):return None #remove this line when code is added.# SQL statement to insert 6 fields for a player added to the table # Use a with statement to execute the query def delete_player(player):return None…
In java create an application to manage your data base information the database is already created in mysql tables, the tables are fill, So the user can use your database application user friendly Retrieve all data: Given a table name, retrieve all data from the table and present it to the user. Average: Given a table name and a column name, return the average of the column. Here the assumption is that the column type will be numeric (e.g., cost column). Insert: Given a table name, your program should show the column names of that table and ask the users to input new data to the table. In case of errors, your program should directly show the MySQL errors to the users. Assumption 1: Users will enter data according to the database constraints. Assumption 2: Users will input one record at a time. Delete: Given a table name, your program should show the column names of that table and ask the users to input data that they want to delete. Assumption 1: Users will enter data according to the…
calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100
Design and Implement “To do list” app same as shown below, save data in local database (SQLite) and database name should be your full name.