Assignment_1: 1. Create table customer with four attributes number, name, address and telephone number. Each customer has a unique number and the name can be up to 14 characters. 2. Add a new attribute ssn to this table. Each customer must have an ssn and it is unique. 3. Redefine the column address to become fixed length with size=20.

Assignment_1: 1. Create table customer with four attributes number, name, address and telephone number. Each customer has a unique number and the name can be up to 14 characters. 2. Add a new attribute ssn to this table. Each customer must have an ssn and it is unique. 3. Redefine the column address to become fixed length with size=20.

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

-- 1 - Write a view to show all data from Sales.Sales Person table
Task 2: StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.
1. Create one new table Courses_xxxx. Your table names must follow the above format(table name is case sensitive) with following fields in correct data types. This table will be used in yourproject.cid: auto_increment integer, primary key name: varchar(200), unique, NOT NULL term: varchar(200), NOT NULL enrollment: int, NOT NULL Fid: int, NOT NULL, a foreign key to TECH3740.Faculty table. Rid: int, NOT NULL, a foreign key to TECH3740.Rooms table. aid: int, NOT NULL, a foreign key to TECH3740.Admin table.
For this problem create a (temporary) table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor, and adds a tuple to the temporary table consisting of the instructors ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. If the instructor already has an entry in the table,then the procedure makes sure the total number of courses taught in the temporary table is up-to-date. You must name your procedure: Written in PostgreSQL
Task 5:The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team. You do not need to create a new table in the database schema. I found the answer but it wroten on paper so its really hard to understand what it is, that's why I am posting this question again.
PLZ HELP WITH THE FOLLOWING: make the following work select MOVIE_NAME, MOVIE_YEAR from MOVIE where MOVIE_COST > (select a.MOVIE_COST from MOVIE a, PRICE b where a.PRICE_CODE = b.PRICE_CODE and b.PRICE_DESC ="weekly Special"); CREATE TABLE MEMBERSHIP ( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEMNUM_PK PRIMARY KEY, MEM_FNAME VARCHAR(30) NOT NULL, MEM_LNAME VARCHAR(30) NOT NULL, MEM_STREET VARCHAR(30), MEM_CITY VARCHAR(10), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER(2) ); CREATE TABLE RENTAL ( RENT_NUM CHAR(4) CONSTRAINT RENTAL_RENTNUM_PK PRIMARY KEY, RENT_DATE DATE, MEM_NUM CHAR(3), CONSTRAINT RENTAL_MEMNUM_FK FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP ); CREATE TABLE PRICE ( PRICE_CODE CHAR(1) CONSTRAINT PRICE_PRICECODE_PK PRIMARY KEY, PRICE_DESC VARCHAR(20), PRICE_RENTFEE NUMBER (3, 1), PRICE_DAILYATFEE NUMBER(3, 1) ); CREATE TABLE MOVIE ( MOVIE_NUM CHAR(4) CONSTRAINT MOVIE_MOVIENUM_PK PRIMARY KEY, MOVIE_NAME VARCHAR(30) NOT NULL,…
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.
Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.
Task 4: The Driver Relationship team wants to have quick search options for the active drivers. The team specifically mentioned that they are using first name, last name and driving license ID to search the drivers. Create an index called NameSearch on the ACTIVE_DRIVERS table created in task 3. ASNWER IN MYSQL PLEASE
Scenario and Database Model: Instant Ride InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the Instant Ride mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email: USER_ID 3001 3002 3003 3004 3005 3006 3007 3008 USERS Table 2001 2002 2003 2004 USER_FIRST_NAME Willie Justin Anthony Ece Jack Ryan Nursin Sarah Bobby Randy Jose DRIVERS Table Nursin Butler Howard In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information: Walker DRIVER_ID DRIVER_FIRST_NAME DRIVER LAST NAME DRIVER DRIVING LICENSE_ID…