SQL Assignment | Online Project | Homework Help

SQL stands for structured query language. SQL is a language which is used to communicate in various ways with the database at the back end. As per ANSI, the SQL is the standard language for the relational database management systems. The statements in SQL are used for updating the data on the database or to retrieve data from the database. Some of the most common relational database management systems that are using the SQL language are Oracle, Microsoft SQL server, Ingres, Access and Sybase. However most of the database management systems use the SQL language but almost all of them have certain proprietary extensions that can be used with their own system only. However the basic and standard SQL commands like select, insert, update, delete, drop and create are sufficient for performing any level of interactions with the database. We provide extremely reliable help with SQL assignment.  SQL commands provide immediate and quick results. SQL is the specific language for the database. The SQL language is helpful in the creation, deletion, fetching of the rows and performing any modifications on the row.  Many different versions of the SQL are existing simultaneously. SQL is used comprehensively because it allows the users to access or retrieve the data in the relational database management system. SQL permits users to describe the data. SQL commands are highly helpful in defining the data and in the manipulation of the defined data. Through the SQL modules, pre compilers and libraries the SQL language helps to embed in the other languages. The SQL language permits the users of the system to create and drop the databases and the tables. Our help with SQL homework is extremely helpful to students in getting consistently higher grades in their end semester examination. SQL project help is a strong focus area of ours as the service providers.  The SQL language permits the users to create and view the stored procedures and the other functions in the database. The SQL language allows the users to set various kinds of permissions on the tables, views and procedures. While we carry out the SQL command for any relational database management system, then the system finds out the best way to carry out the request. And then the SQL engine figures out how to interpret the given task. A number of the entities and components are included in the SQL process. These entities are optimization engines, query dispatcher, SQL query engine and classic query engine. Classic query engine is meant for handling all the non SQL queries but one thing has to be noticed that SQL query engine will not be handling logical files. The language SQL can be classified into the following categories.

  1. The Data query language.
  2. The Data manipulation language.
  3. The Data control language.
  4. The Data definition language.

 

A relational database management system is a certain specific class of database management system that is created on the basis of the relational model as introduced to the world by E.F. Codd. The data in relational database management system is stored in the form of the database objects which are known as the tables. A table is the congregation of the interrelated data entries and it consists of columns and the rows. We have a dedicated team of experts who offer help with SQL project that provide assistance on SQL language area. 

Help with SQL assignment provides assistance to students, research scholars and professionals. We have many services to choose from on the SQL topic to avail help with SQL homework. We are the leading online help provider in SQL project help and the other related areas. Students can find the answers to all the doubts in SQL in our SQL assignment help. We have a set of dedicated tutors on the subject who provide SQL project help. At SQL assignment help the expert tutors are available who themselves have a masters or a PhD degree in their respective field. Students from all over the world have availed our SQL project help. SQL homework help gives apt and clear solutions to the assignments on SQL language. SQL assignment help is the right place for the students who are seeking help with SQL assignments. Our online experts in SQL assignment help have years of experience and provide help to the students from the undergraduate level to research levels. Our experts in SQL homework help have a PhD or a masters’ degree. In SQL homework help we offer completely plagiarism free material in the assignment solutions. Our draft solution in SQL project help is checked several times for plagiarism before the final draft is sent to the students. In SQL assignment help we guarantee full secrecy of identity of the clients. In SQL homework help we have high regards for the timelines stipulated by our clients as this is the backbone of this service provider industry. The students can avail the benefit of live chat facility or the call me back feature incorporated in the website for help with SQL assignment. We provide best services to offer SQL assignment help.

 

Logical and Physical Database Design Homework Help 

Part A:Step 1

Answer:

NORMALIZATION:

1st Normal Form

Student:(StudentNo, firstName, lastName, street, city, state, postcode, mobile phone, email, dob, category, nationality, special needs, comments, status, major, minor) 

Adviser:(AdvisorID, firstName, lastName, position, department, phone, email, room,CourseID, title, instructor, phone, email, room, department)

ResidenceHall:  (ResidenceHallID, name, address, phone, manager,PlaceNumber, ResidenceHallID, RoomID, rent)

Apartment:  (ApartmentID, address, bedrooms, RoomID, rent)

Lease:  (LeaseID, Student No, PlaceNumber, Durration, StartDate, EndDate) 

2nd Normal Form

Student:(StudentNo, firstName, lastName, street, city, state, postcode, mobile phone, email, dob, category, nationality, special needs, comments, status, major, minor) 

Adviser:(AdvisorID, firstName, lastName, position, department, phone, email, room)

Course:(CourseID, title, instructor, phone, email, room, department)

ResidenceHall: SQL Assignment help (ResidenceHallID, name, address, phone, manager,PlaceNumber, ResidenceHallID, RoomID, rent)

Apartment:  (ApartmentID, address, bedrooms, RoomID, rent)

Lease:  (LeaseID, Student No, PlaceNumber, Durration, StartDate, EndDate)

 

3rd Normal Form  Oracle Homework Help

Student:(StudentNo, firstName, lastName, street, city, state, postcode, mobile phone, email, dob, category, nationality, special needs, comments, status, major, minor) 

Adviser:(AdvisorID, firstName, lastName, position, department, phone, email, room)

Course:(CourseID, title, instructor, phone, email, room, department)

Places: (PlaceNumber) sql assignment with solution

ResidenceHall:  (ResidenceHallID, name, address, phone, manager)

ResidenceHallRoom: Oracle homework help (PlaceNumber, ResidenceHallID, RoomID, rent)

Apartment:  (ApartmentID, address, bedrooms)

ApartmentRoom:  (PlaceNumber, ApartmentID, RoomID, rent)

Lease:  (LeaseID, Student No, PlaceNumber, Durration, StartDate, EndDate) 

Kin : (KINID,StudentNO,FirstName,LastName,Relationship,Street,City,State,PostCode,Phone) 

 

 Oracle Assignment Help

Student:(StudentNo, firstName, lastName, street, city, state, postcode, mobile phone, email, dob, category, nationality, special needs, comments, status, major, minor) 

Adviser:(AdvisorID, firstName, lastName, position, department, phone, email, room)

Course:(CourseID, title, instructor, phone, email, room, department)

Places: SQL Assignment Questions with Answers (PlaceNumber)

ResidenceHall:  (ResidenceHallID, name, address, phone, manager)

ResidenceHallRoom:  (PlaceNumber, ResidenceHallID, RoomID, rent)

Apartment:  (ApartmentID, address, bedrooms) Oracle homework help

ApartmentRoom:  (PlaceNumber, ApartmentID, RoomID, rent)

Lease:  (LeaseID, Student No, PlaceNumber, Durration, StartDate, EndDate) 

Kin : (KINID,StudentNO,FirstName,LastName,Relationship,Street,City,State,PostCode,Phone)

Business Rule 1  ERD Homework Help

 

Advisor --------- teaches ---------- Student

 

Student ------- lease ------Apartment

 

Course -------- taken by -------- Student 

 

Business Rule 2 ERD ASSIGNMENT HELP

Advisor --------- teaches ---------- Student

 

Student ------- lease ------ApartmentRoom

 

Student-------Enroll------Course

Part A:Step2 

SQL Assignment Help

Data Definition:

ADVISER

COLUMN

DATA TYPE

DESCRIPTOIN

CONSTRAINTS

ADVISERID

NUMBER

THE ID OF THE ADVISOR

PRIMARY KEY

FIRST_NAME

VARCHAR2

THE ADVISOR’S FIRST NAME

 

LAST_NAME

VARCHAR2

THE ADVISOR’S LAST NAME

 

POSITION

VARCHAR2

THE ADVISOR’S POSITION

 

DEPARTMENT

SQL HOMEWORK Help

THE ADVISOR’S DEPARTMENT

 

PHONE

VARCHAR(2)

THE ADVISOR’S PHONE

 

ROOM

VARCHAR(2)

THE ADVISOR’S OFFICE ROOM NUMBER

 

 

STUDENT

COLUMN

DATA TYPE

DESCRIPTOIN

CONSTRAINTS

BANNERNUMBER

NUMBER

THE STUDENT ID

PRIMARY KEY

FIRST_NAME

VARCHAR2

STUDENT’S FIRST NAME

 

LAST_NAME

VARCHAR2

STUDENT’S LAST NAME

 

STREET

VARCHAR2

STREET ADDRESS

 

CITY

VARCHAR2

ADDRESS CITY

 

STATE

VARCHAR2

ADDRESS STATE

 

POSTCODE

VARCHAR2

ADDRESS POSTCODE

 

MOBILE

VARCHAR2

STUDENT’S MOBILE NUMBER

 

EMAIL

VARCHAR2

STUDENT’S EMAIL

 

DOB

DATE

STUDENTS DOB

 

CATEGORY

VARCHAR2

STUDENT’S CATEGORY

CHECK (1ST – 4TH YEAR UNDERGRADUATE, GRADUATE, POST-GRADUATE)

NATIONALITY

VARCHAR2

STUDENT’S NATIONALITY

 

SPECIAL_NEEDS

CLOB

DESCRIPTION OF ANY SPECIAL NEEDS

 

COMMENTS

CLOB

ANY OTHER COMMENTS

SQL ASSIGNMENT Help

STATUS

VARCHAR2

THE STUDENT’S STATUS

CHECK (WAITING, PLACED)

MAJOR

VARCHAR2

THE STUDENT’S MAJOR

 

MINOR

VARCHAR2

THE STUDENT’S MINOR

 

ADVISERID

NUMBER

THE STUDENT’S ADVISER

FOREIGN KEY TO ADVISOR TABLE

 

COURSE

COLUMN

DATA TYPE

DESCRIPTOIN

CONSTRAINTS

COURSEID

NUMBER

THE COURSE NUMBER

PRIMARY KEY

TITLE

VARCHAR2

THE COURSE TITLE

 

INSTRUCTOR

VARCHAR2

THE INSTRUCTOR’S NAME

 

PHONE

VARCHAR2

THE INSTRUCTOR’S PHONE NUMBER

 

EMAIL

VARCHAR2

THE INSTRUCTOR’S EMAIL

Oracle Homework Help

ROOMNUMBER

NUMBER

THE COURSE ROOM NUMBER

 

DEPARTMENT

VARCHAR2

THE COURSE DEPARTMENT

 

 

APARTMENT

COLUMN

DATA TYPE

DESCRIPTOIN

CONSTRAINTS

APARTMENTID

NUMBER

THE APARTMENT ID

PRIMARY KEY

ADDRESS

VARCHAR2

THE APARTMENT ADDRESS

 

BEDROOMS

NUMBER

THE NUMBER OF BEDROOMS

 

 

 PLACES

COLUMN

DATA TYPE

DESCRIPTOIN

CONSTRAINTS

PLACENUMBER

NUMBER

THE PLACE NUMBER

PRIMARY KEY

 

APARTMENTROOM

COLUMN

DATA TYPE

DESCRIPTOIN

CONSTRAINTS

PLACENUMBER

NUMBER

THE PLACE NUMBER

PRIMARY KEY,

FOREIGN KEY TO PLACES TABLE

APARTMENTID

NUMBER

THE APARTMENT NUMBER

FOREIGN KEY TO APARTMENT TABLE

ROOMID

NUMBER

THE ROOM NUMBER

SQL Homework Help

RENT

NUMBER(8,2)

THE MONTHLY RENT

 

 

 RESIDENCEHALL

COLUMN

DATA TYPE

DESCRIPTOIN

CONSTRAINTS

RESIDENCEHALLID

NUMBER

THE RESIDENCE HALL ID

PRIMARY KEY

NAME

VARCHAR2

THE NAME OF THE RESIDENCE HALL

 

ADDRESS

VARCHAR2

THE RESIDENCE HALL ADDRESS

SQL Assignment Help

PHONE

VARCHAR2

THE RESIDENCE HALL PHONE NUMBER

 

MANAGER

VARCHAR2

THE MANAGER’S NAME

 

 

 RESIDENCEHALLROOM

COLUMN

DATA TYPE

DESCRIPTOIN

CONSTRAINTS

PLACENUMBER

NUMBER

THE PLACE NUMBER

PRIMARY KEY,

FOREIGN KEY TO PLACES TABLE

RESIDENCEHALLID

NUMBER

THE RESIDENCE HALL ID

FOREIGN KEY TO RESIDENCE TABLE

ROOMID

NUMBER

THE ROOM NUMBER

SQL Homework help

RENT

NUMBER(8,2)

THE MONTHLY RENT

 

 

 SQL Homework Help 

COLUMN

DATA TYPE

DESCRIPTOIN

CONSTRAINTS

LEASEID

NUMBER

THE LEASE ID

PRIMARY KEY

BANNERNUMBER

NUMBER

THE STUDENT ID

FOREIGN KEY TO STUDENT TABLE

PLACENUMBER

NUMBER

THE PLACE NUMBER

FOREIGN KEY TO PLACES TABLE

DURRATION

NUMBER

THE NUMBER OF SEMESTERS

CHECK (1,2,3)

STARTDATE

DATE

THE DATE THAT THE LEASE BEGINS

 

ENDDATE

DATE

THE DATE THAT THE LEASE ENDS

 

 

Part A:Step3

Create Tables:

CREATE TABLE ADVISER (

  ADVISERID NUMBER PRIMARY KEY,

  FIRST_NAME VARCHAR2(45) NOT NULL,

  LAST_NAME VARCHAR2(45) NOT NULL,

  POSITION VARCHAR2(45) NOT NULL,

  DEPARTMENT VARCHAR2(45) NOT NULL,

  PHONE VARCHAR2(45) NOT NULL,

  EMAIL VARCHAR2(45) NOT NULL,

  ROOM VARCHAR(8) NOT NULL

);help with sql assignment

 

CREATE TABLE STUDENT (

  BANNERNUMBER NUMBER PRIMARY KEY,

  FIRST_NAME VARCHAR2(45) NOT NULL,

  LAST_NAME VARCHAR2(45) NOT NULL,

  STREET VARCHAR2(45) NOT NULL,help with sql homework

  CITY VARCHAR2(45) NOT NULL,

  STATE VARCHAR2(45) NOT NULL,

  POSTCODE VARCHAR2(45) NOT NULL,

  MOBILE VARCHAR2(45),

  EMAIL VARCHAR2(45) NOT NULL,

  DOB DATE NOT NULL,

  CATEGORY VARCHAR2(45) NOT NULL,

  NATIONALITY VARCHAR2(45) NOT NULL,

  SPECIAL_NEEDS CLOB,

  COMMENTS CLOB,

  STATUS VARCHAR2(45) NOT NULL,

  MAJOR VARCHAR2(45) NOT NULL,

  MINOR VARCHAR(45),

  ADVISER_ID NUMBER NOT NULL,

  CONSTRAINT FK_STUDENT_ADVISER

    FOREIGN KEY (ADVISER_ID)

    REFERENCES ADVISER(ADVISERID),

  CONSTRAINT CHK_STUDENT_STATUS CHECK

    (STATUS IN ('PLACED','WAITING')),

  CONSTRAINT CHK_STUDENT_CAT CHECK

    (CATEGORY IN ('FIRST-YEAR UNDERGRADUATE', 'SECOND-YEAR UNDERGRADUATE',

      'THIRD-YEAR UNDERGRADUATE', 'FOURTH-YEAR UNDERGRADUATE',

      'GRADUATE', 'POST-GRADUATE'))

); sql project help

 

CREATE TABLE COURSE (

  COURSEID NUMBER PRIMARY KEY,

  TITLE VARCHAR2(45) NOT NULL,

  INSTRUCTOR VARCHAR2(45) NOT NULL,

  PHONE VARCHAR2(45),

  EMAIL VARCHAR2(45),

  ROOM NUMBER NOT NULL,

  DEPARTMENT VARCHAR2(45) NOT NULL

);

 

CREATE TABLE APARTMENT (

  APARTMENTID NUMBER PRIMARY KEY,

  ADDRESS VARCHAR2(45) NOT NULL,

  BEDROOMS NUMBER NOT NULL

);

 

CREATE TABLE PLACES (

  PLACENUMBER NUMBER PRIMARY KEY

);

 

CREATE TABLE APARTMENTROOM (

  PLACENUMBER NUMBER PRIMARY KEY,

  APARTMENTID NUMBER NOT NULL,

  ROOMID NUMBER NOT NULL,

  RENT NUMBER(8,2) NOT NULL,

  CONSTRAINT FK_APTROOM

    FOREIGN KEY (APARTMENTID)

    REFERENCES APARTMENT(APARTMENTID),

  CONSTRAINT FK_APT_PLACE

    FOREIGN KEY (PLACENUMBER)

    REFERENCES PLACES(PLACENUMBER)

);

 

CREATE TABLE RESIDENCEHALL (

  RESIDENCEHALLID NUMBER PRIMARY KEY,

  NAME VARCHAR2(45) NOT NULL,

  ADDRESS VARCHAR2(45) NOT NULL,

  PHONE VARCHAR2(45) NOT NULL,

  MANAGER VARCHAR2(45) NOT NULL

);

 

CREATE TABLE RESIDENCEHALLROOM (

  PLACENUMBER NUMBER PRIMARY KEY,

  RESIDENCEHALLID NUMBER NOT NULL,

  ROOMID NUMBER NOT NULL,

  RENT NUMBER(8,2) NOT NULL,

  CONSTRAINT FK_RH_ROOM

    FOREIGN KEY (RESIDENCEHALLID)

    REFERENCES RESIDENCEHALL(RESIDENCEHALLID),

  CONSTRAINT FK_RH_PLACE

    FOREIGN KEY (PLACENUMBER)

    REFERENCES PLACES(PLACENUMBER)

); sql homework help

 

CREATE TABLE LEASE (

  LEASEID NUMBER PRIMARY KEY,

  BANNERNUMBER NUMBER NOT NULL,

  PLACENUMBER NUMBER NOT NULL,

  DURRATION INT NOT NULL,

  STARTDATE DATE NOT NULL,

  ENDDATE DATE,

  CONSTRAINT FK_LEASE_STUDENT

    FOREIGN KEY (BANNERNUMBER)

    REFERENCES STUDENT(BANNERNUMBER),

  CONSTRAINT FK_LEASE_PLACE

    FOREIGN KEY (PLACENUMBER)

    REFERENCES PLACES(PLACENUMBER),

  CONSTRAINT CHK_DURRATION CHECK

    (DURRATION IN (1,2,3))

); 

 

Insert into Tables: sql assignment help

 

INSERT INTO COURSE VALUES (1, 'JAVA PROGRAMMING', 'MARY WILLIAMS', '8881231234', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', 20, 'INFORMATION SYSTEMS');

INSERT INTO COURSE VALUES (2, 'C# PROGRAMMING', 'DANIEL TOSH', '8885551234', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', 21, 'INFORMATION SYSTEMS');

INSERT INTO COURSE VALUES (3, 'PHP PROGRAMMING', 'CALLIE ROBBINS', '8885556666', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', 26, 'INFORMATION SYSTEMS');

INSERT INTO COURSE VALUES (4, 'C++ PROGRAMMING', 'DANIEL TOSH', '8885551234', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', 21, 'INFORMATION SYSTEMS');

INSERT INTO COURSE VALUES (5, 'Java PROGRAMMING', 'CALLIE ROBBINS', '8885556226', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', 26, 'INFORMATION SYSTEMS'); 

 

INSERT INTO ADVISER VALUES (1, 'GREG', 'POLLENS', 'ACADEMIC ADVISER', 'INFORMATION SYSTEMS', '8885552232', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', '150A');

INSERT INTO ADVISER VALUES (2, 'NANCY', 'SMITH', 'ACADEMIC ADVISER', 'INFORMATION SYSTEMS', '8885552233', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', '150B');

INSERT INTO ADVISER VALUES (3, 'RONALD', 'MCDONALD', 'ACADEMIC ADVISER', 'INFORMATION SYSTEMS', '8885552234', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', '19C');

INSERT INTO ADVISER VALUES (4, 'NAN', 'SMITH', 'ACADEMIC ADVISER', 'INFORMATION SYSTEMS', '8885552233', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', '150B');

INSERT INTO ADVISER VALUES (5, 'John', 'MCDONALD', 'ACADEMIC ADVISER', 'INFORMATION SYSTEMS', '8885552234', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', '19C'); 

 

INSERT INTO STUDENT VALUES (1, 'DONALD', 'DUCK', '123 EAST STREET', 'PITTSBURGH', 'PA', '15220', '8885559999', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', SYSDATE, 'FIRST-YEAR UNDERGRADUATE', 'AMERICAN', 'NONE', 'GREAT STUDENT', 'PLACED', '.NET DEVELOPMENT', 'ENGLISH', 1);

INSERT INTO STUDENT VALUES (2, 'MICKEY', 'MOUSE', '124 EAST STREET', 'PITTSBURGH', 'PA', '15220', '8885559999', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', SYSDATE, 'THIRD-YEAR UNDERGRADUATE', 'AMERICAN', 'NONE', 'GREAT STUDENT', 'PLACED', '.NET DEVELOPMENT', 'SPANISH', 2);

INSERT INTO STUDENT VALUES (3, 'ROCKY', 'RODENT', '123 EAST STREET', 'PITTSBURGH', 'PA', '15220', '8885559999', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', SYSDATE, 'GRADUATE', 'AMERICAN', 'NONE', 'GREAT STUDENT', 'WAITING', '.NET DEVELOPMENT', 'GERMAN', 3);

INSERT INTO STUDENT VALUES (4, 'MICKEY', 'MOUSE', '124 EAST STREET', 'PITTSBURGH', 'PA', '15220', '8885559999', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', SYSDATE, 'THIRD-YEAR UNDERGRADUATE', 'AMERICAN', 'NONE', 'GREAT STUDENT', 'PLACED', '.NET DEVELOPMENT', 'SPANISH', 2);

INSERT INTO STUDENT VALUES (5, 'ROCKY', 'RODENT', '123 EAST STREET', 'PITTSBURGH', 'PA', '15220', '8885559999', ' This email address is being protected from spambots. You need JavaScript enabled to view it. ', SYSDATE, 'GRADUATE', 'AMERICAN', 'NONE', 'GREAT STUDENT', 'WAITING', '.NET DEVELOPMENT', 'GERMAN', 3); 

 

INSERT INTO RESIDENCEHALL VALUES (1, 'ADAMS HALL', '123 HALL BLVD.', '8885557878', 'BARBARA GORDON');

INSERT INTO RESIDENCEHALL VALUES (2, 'JACKSON HALL', '124 HALL BLVD.', '8885557877', 'BRUCE WAYNE');

INSERT INTO RESIDENCEHALL VALUES (3, 'JEFFERSON HALL', '125 HALL BLVD.', '8885557876', 'JEFF GOLDBLOOM');

INSERT INTO RESIDENCEHALL VALUES (4, 'JACKSON HALL', '124 HALL BLVD.', '8885557877', 'BRUCE WAYNE');

INSERT INTO RESIDENCEHALL VALUES (5, 'JEFFERSON HALL', '125 HALL BLVD.', '8885557876', 'JEFF GOLDBLOOM'); 

 

INSERT INTO PLACES VALUES (1);

INSERT INTO PLACES VALUES (2);

INSERT INTO PLACES VALUES (3);

INSERT INTO PLACES VALUES (4);

INSERT INTO PLACES VALUES (5);

INSERT INTO PLACES VALUES (6);

 

INSERT INTO RESIDENCEHALLROOM VALUES (1, 1, 1, 500);

INSERT INTO RESIDENCEHALLROOM VALUES (2, 2, 1, 560);

INSERT INTO RESIDENCEHALLROOM VALUES (3, 3, 1, 600);

INSERT INTO RESIDENCEHALLROOM VALUES (4, 2, 1, 560);

INSERT INTO RESIDENCEHALLROOM VALUES (5, 3, 1, 600);

 

INSERT INTO APARTMENT VALUES (1, '283 APT AVENUE', '5');

INSERT INTO APARTMENT VALUES (2, '283 APT AVENUE', '3');

INSERT INTO APARTMENT VALUES (3, '283 APT AVENUE', '4');

INSERT INTO APARTMENT VALUES (4, '283 APT AVENUE', '3');

INSERT INTO APARTMENT VALUES (5, '283 APT AVENUE', '4'); 

 

INSERT INTO APARTMENTROOM VALUES (4, 1, 1, 800);

INSERT INTO APARTMENTROOM VALUES (5, 2, 1, 900);

INSERT INTO APARTMENTROOM VALUES (6, 3, 1, 1100);

INSERT INTO APARTMENTROOM VALUES (7, 2, 1, 900);

INSERT INTO APARTMENTROOM VALUES (8, 3, 1, 1100); 

 

INSERT INTO LEASE VALUES (1, 1, 1, 3, SYSDATE, NULL);

INSERT INTO LEASE VALUES (2, 2, 2, 2, SYSDATE, NULL);

INSERT INTO LEASE VALUES (3, 3, 6, 1, SYSDATE, NULL);

INSERT INTO LEASE VALUES (4, 2, 2, 2, SYSDATE, NULL);

INSERT INTO LEASE VALUES (5, 3, 6, 1, SYSDATE, NULL);