Write appropriate SQL DDL statements for declaring the database "Employee", assign admin privilege to user "AMAL" Write appropriate SQL DDL statements for declaring the table PERSONS. Specify all constraints: Null No varchar(30) No FirstName varchar(30) No Address City Field PersonID LastName Type int varchar(50) YES varchar(30) YES key PRIMARY

Write appropriate SQL DDL statements for declaring the database "Employee", assign admin privilege to user "AMAL" Write appropriate SQL DDL statements for declaring the table PERSONS. Specify all constraints: Null No varchar(30) No FirstName varchar(30) No Address City Field PersonID LastName Type int varchar(50) YES varchar(30) YES key PRIMARY

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

assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns all the columns from the rows where Trading_Symbol starts with "SU".
Assume that the Authors table is already built in the database with the following specifications: Authors: Column Name Data Type constrains Authors ID Author Name Varchar2(10) |Varchar2(30) Primary key Unique You Need to Create the Books table with the following specifications Column Name Data Type Constrains ISBN Book Title Book Price Author id Number (10) Varchar2(40) Number (4,2) Varchar2(10) Primary key Not Null referencing the Author_ID in the Author Table Complete the create statement by drag and drop the correct word: Create Table lblank (ISBN Number (10) plank, Book Title Varchar2blank ) Not Null, Book Price Number(4, 2), Auther IR blank (10) references Jolank (blank ); Author ID Books Number||Authors Not Nul Varchar2| Primary Key 40 h (United States)
PROBLEM -1 The table name is "users" and its structure is shown below. You can insert as many rows in your database as you want to check your queries. ID int Name varchar(100) Email varchar(50) Influence_count int Member_since date Multiplier int Task Find all the unique multipliers in the table and show them in descending order. Find the names where multipliers are odd. Find the name, email and member_since of users who became a member of the platform between 31st of July, 2020 and 15th of August, 2020 Show the name and email of the latest 5 members. Find all ids and email addresses where the TLD (Top Level Domain) is 'com' (ends with 'com') Show the name and email of the person who has the highest number of influence counts. Retrieve the id, name, email and influence count of the users who have 'u,o,v,n,s,m' - all of these in their name. Find highest influence_count for each multiplier that is greater than 9. Count the number of users in each multiplier who has joined after the month…
SQL Database help
Write SQL code for the following: Create a stored procedure “setRelocationFee” to set the relocation fee for a givenemployee. If the employee’s office is in San Francisco, the relocation fee is $10000; ifthe employee’s office is in Boston, the relocation fee is $8000; if the employee’s officeis in London, the relocation fee is $20000; if the employee works in other offices, therelocation fee is $15000. (see image for table structure) I am stuck for the part that I have to select employeeNumber and officeCode and set the relocationFee to be able to obtain the result but I do not know how. Bellow is what I have gotten. Delimiter| CREATE PROCEDURE setRealocationFee(IN EmployeeID INT(11), OUT realocationFee INT(5))
SQL code for: (1) Hint: A NULL in the hours column should be considered as zero hours. Find the ssn, lname, and the total number of hours worked on projects for every employee whose total is less than 40 hours. Sort the result by lname */ /* (2) For every project that has more than 2 employees working on it: Find the project number, project name, number of employees working on it, and the total number of hours worked by all employees on that project. Sort the results by project number. /* (3) For every employee who has the highest salary in their department: Find the dno, ssn, lname, and salary. Sort the results by department number. */ /* (4) For every employee who does not work on any project that is located in Houston: Find the ssn and lname. Sort the results by lname /* (5) Hint: This is a DIVISION query For every employee who works on every project that is located in Stafford: Find the ssn and lname. Sort the results by lname */
database: sql Q1. Create the following tables: Carrier Attribute name Type Size Constraint carrierID Varchar2 10 Primary key carrierName Varchar2 100 NOT NULL Phone Varchar2 50 LIKE ‘+966%’ Range Varchar2 30 Value is either ‘International’ or ‘Local’ Review Attribute name Type Size Constraint ReviewID INT Primary key Stars INT NOT NULL Comment Varchar2 70 Name Varchar2 50 Default ’User’ CustomerID INT Foreign key references customers ProductID INT
assume that a database has a table named Stock, with thefollowing columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns the Trading_Symbol column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100.
Computer science
True or False below: Given two relations named A and B, if we q-JOIN A and B, the maximum number of attributes in the result relation could be (the number of attributes of A) times(*) the number of attributes of B). * in an SQL SELECT statement means “all the tuples”. In relational algebra, Cartesian Product (X) can be implemented using the q-JOIN operator. Cartesian Product ISA q-JOIN where q-condition always evaluates to true. SQL is based on Predicate Calculus. A query in SQL always specifies what should be included in the query result.
QUESTION 12 Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program declare employeeRecord employee%TYPE: ename varchar2; begin fetch ename, salary inside employeeRecord from employee where enum= 'ES: DBMS OUTPUT.PUT_LINE(employee.ename" | employee.Salary): end:
Table name: Supplier Column Name Role Data Type Length Constraint supplierID Stores the ID of a supplier Number 10 Primary key supplierFName Stores the first name of a supplier Varchar2 30 Cannot be null supplierLName Stores the last Name of a supplier Varchar2 30 Cannot be null supplierDOB Stores the date of birth of a supplier Date - supplierNBPro Stores the number of products supplied by a supplier Number 3 Should be greater than 10 a. Write in SQL a statement that adds a new column named comapnyID of type char(5). This column should be defined as a foreign key that relates the table Supplier to the table Company b. Write in SQL a query that displays the ids of the suppliers who supply the highest number of products. c. Create a view named ‘SupplierDetails’ to hold all the details of suppliers whose last names start with ‘bait’ and who supply between 50 and 200 products.