Skip to main content

SQL Set Operators

SQL Set Operators   Traditional Set Operators: Union Compatibility:     Requirement for the traditional set operators.    Strong requirement.                         - Same number of columns.                         - Each corresponding column is compatible.                         - Positional correspondence.     Apply to similar tables by removing columns first. SQL UNION Example:           Example 1: Retrieve basic data about all university people.                     SELECT FacNo AS PerNo, FacFirstName                                      ...
Post a Comment

Database Insert Statements

Database Insert Statements

University Database Insert Statements:

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('123-45-6789','HOMER','WELLS','SEATTLE','WA','IS','FR',3.00,'98121-1111');

 

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('124-56-7890','BOB','NORBERT','BOTHELL','WA','FIN','JR',2.70,'98011-2121');

 

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('234-56-7890','CANDY','KENDALL','TACOMA','WA','ACCT','JR',3.50,'99042-3321');

 

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('345-67-8901','WALLY','KENDALL','SEATTLE','WA','IS','SR',2.80,'98123-1141');

 

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('456-78-9012','JOE','ESTRADA','SEATTLE','WA','FIN','SR',3.20,'98121-2333');

 

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('567-89-0123','MARIAH','DODGE','SEATTLE','WA','IS','JR',3.60,'98114-0021');

 

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('678-90-1234','TESS','DODGE','REDMOND','WA','ACCT','SO',3.30,'98116-2344');

 

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('789-01-2345','ROBERTO','MORALES','SEATTLE','WA','FIN','JR',2.50,'98121-2212');

 

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('876-54-3210','CRISTOPHER','COLAN','SEATTLE','WA','IS','SR',4.00,'98114-1332');

 

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('890-12-3456','LUKE','BRAZZI','SEATTLE','WA','IS','SR',2.20,'98116-0021');

 

INSERT INTO student

        (stdNo, stdFirstName, stdLastName, stdCity,

         stdState, stdMajor, stdClass, stdGPA, stdZip)

        VALUES ('901-23-4567','WILLIAM','PILGRIM','BOTHELL','WA','IS','SO',3.80,'98113-1885');

 

 

-----------------------------------------------------------------------------

 

 

INSERT INTO course

        (CourseNo, crsDesc, CrsUnits)

        VALUES ( 'FIN300','FUNDAMENTALS OF FINANCE',4);

 

INSERT INTO course

        (CourseNo, crsDesc, CrsUnits)

        VALUES ( 'FIN450','PRINCIPLES OF INVESTMENTS',4);

       

INSERT INTO course

        (CourseNo, crsDesc, CrsUnits)

        VALUES ( 'FIN480','CORPORATE FINANCE',4);

       

INSERT INTO course

        (CourseNo, crsDesc, CrsUnits)

        VALUES ('IS320','FUNDAMENTALS OF BUSINESS PROGRAMMING',4 );

 

INSERT INTO course

        (CourseNo, crsDesc, CrsUnits)

        VALUES ( 'IS460','SYSTEMS ANALYSIS',4);

       

INSERT INTO course

        (CourseNo, crsDesc, CrsUnits)

        VALUES ( 'IS470','BUSINESS DATA COMMUNICATIONS',4);

 

INSERT INTO course

        (CourseNo, crsDesc, CrsUnits)

        VALUES ('IS480','FUNDAMENTALS OF DATABASE MANAGEMENT',4 );

 

-----------------------------------------------------------------------

 

 

 

INSERT INTO faculty

        (FacNo, FacFirstName, FacLastName, FacCity, FacState,

         FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)

         VALUES ('543-21-0987','VICTORIA','EMMANUEL','BOTHELL','WA','MS','PROF',120000.0,'','2005-04-15','98011-2242');

 

INSERT INTO faculty

        (FacNo, FacFirstName, FacLastName, FacCity, FacState,

         FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)

         VALUES ('765-43-2109','NICKI','MACON','BELLEVUE','WA','FIN','PROF',65000.00,'','2006-04-11','98015-9945');

 

INSERT INTO faculty

        (FacNo, FacFirstName, FacLastName, FacCity, FacState,

         FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)

         VALUES ('654-32-1098','LEONARD','FIBON','SEATTLE','WA','MS','ASSC',70000.00,'543-21-0987','2003-05-01','98121-0094');

 

INSERT INTO faculty

        (FacNo, FacFirstName, FacLastName, FacCity, FacState,

         FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)

         VALUES ('098-76-5432','LEONARD','VINCE','SEATTLE','WA','MS','ASST',35000.00,'654-32-1098','2004-04-10','98111-9921');

 

INSERT INTO faculty

        (FacNo, FacFirstName, FacLastName, FacCity, FacState,

         FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)

         VALUES ('876-54-3210','CRISTOPHER','COLAN','SEATTLE','WA','MS','ASST',40000.00,'654-32-1098','2008-03-01','98114-1332');

 

INSERT INTO faculty

        (FacNo, FacFirstName, FacLastName, FacCity, FacState,

         FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)

         VALUES ('987-65-4321','JULIA','MILLS','SEATTLE','WA','FIN','ASSC',75000.00,'765-43-2109','2009-03-15','98114-9954');

 

 

 

-----------------------------------------------------------------------------

 

 

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (1111,'IS320','SUMMER',2017,'BLM302','10:30:00',NULL,'MW');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (1234,'IS320','FALL',2016,'BLM302','10:30:00','098-76-5432','MW');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (2222,'IS460','SUMMER',2016,'BLM412','13:30:00',NULL,'TTH');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (3333,'IS320','SPRING',2017,'BLM214','08:30:00','098-76-5432','MW');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (4321,'IS320','FALL',2016,'BLM214','15:30:00','098-76-5432','TTH');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (4444,'IS320','WINTER',2017,'BLM302','15:30:00','543-21-0987','TTH');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (5555,'FIN300','WINTER',2016,'BLM207','08:30:00','765-43-2109','MW');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (5678,'IS480','WINTER',2017,'BLM302','10:30:00','987-65-4321','MW');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (5679,'IS480','SPRING',2017,'BLM412','15:30:00','876-54-3210','TTH');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (6666,'FIN450','WINTER',2017,'BLM212','10:30:00','987-65-4321','TTH');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (7777,'FIN480','SPRING',2017,'BLM305','13:30:00','765-43-2109','MW');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (8888,'IS320','SUMMER',2017,'BLM405','13:30:00','654-32-1098','MW');

       

INSERT INTO offering

        (OfferNo, CourseNo, OffTerm, OffYear, OffLocation, OffTime, FacNo, OffDays)

        VALUES (9876,'IS460','SPRING',2017,'BLM307','13:30:00','654-32-1098','TTH');

 

 

 

-----------------------------------------------------------------------------

 

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(1234,'123-45-6789',3.30);

 

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(1234,'234-56-7890',3.50);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(1234,'345-67-8901',3.20);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(1234,'456-78-9012',3.10);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(1234,'567-89-0123',3.80);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(1234,'678-90-1234',3.40);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(4321,'123-45-6789',3.50);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(4321,'124-56-7890',3.20);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(4321,'789-01-2345',3.50);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(4321,'876-54-3210',3.10);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(4321,'890-12-3456',3.40);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(4321,'901-23-4567',3.10);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5555,'123-45-6789',3.20);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5555,'124-56-7890',2.70);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5678,'123-45-6789',3.20);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5678,'234-56-7890',2.80);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5678,'345-67-8901',3.30);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5678,'456-78-9012',3.40);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5678,'567-89-0123',2.60);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5679,'123-45-6789',2.00);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5679,'124-56-7890',3.70);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5679,'678-90-1234',3.30);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5679,'789-01-2345',3.80);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5679,'890-12-3456',2.9);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(5679,'901-23-4567',3.1);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(6666,'234-56-7890',3.1);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(6666,'567-89-0123',3.6);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(7777,'876-54-3210',3.4);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(7777,'890-12-3456',3.7);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(7777,'901-23-4567',3.4);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(9876,'124-56-7890',3.5);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(9876,'234-56-7890',3.2);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(9876,'345-67-8901',3.2);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(9876,'456-78-9012',3.4);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(9876,'567-89-0123',2.6);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(9876,'678-90-1234',3.3);

 

INSERT INTO enrollment

        (OfferNO, StdNo, EnrGrade)

        VALUES(9876,'901-23-4567',4);





Our Official Website : Web Conquerors (https://www.webconquerors.com/) 

Want to get digital services? Contact US

Want to know about our services? Our Services

Labels:

Comments

Post a Comment

Popular posts from this blog

SQL Set Operators

SQL Set Operators   Traditional Set Operators: Union Compatibility:     Requirement for the traditional set operators.    Strong requirement.                         - Same number of columns.                         - Each corresponding column is compatible.                         - Positional correspondence.     Apply to similar tables by removing columns first. SQL UNION Example:           Example 1: Retrieve basic data about all university people.                     SELECT FacNo AS PerNo, FacFirstName                                      ...
Post a Comment
Read more

CREATE TABLE Syntax

CREATE TABLE Syntax CREATE TABLE <table-name> ( <column-list> [<constraint-list>] ). Column list with data types and optional and inline constraints. Optional external constraint list  CONSTRAINT [ ConstraintName ] <Constraint-Spec>            Primary key            Foreign key            Unique            Check CREATE TABLE Statement Example CREATE TABLE Student            ( StdNo CHAR(11),            StdFirstName VARCHAR(50),            StdLastName VARCHAR(50),            StdCity VARCHAR(50),            StdState CHAR(2),            StdZip CHAR(10),            ...
Post a Comment
Read more

Schema

    Schema External Schemas: also called subschemas. Multiple schemas per database correspond to different views of the data. Conceptual Schema: describes all the entities, attributes, and relationships together with integrity constraints. Only one schema per database. Internal Schema: a complete description of the internal model, containing the definitions of stored records, the methods of representation, the data fields, and the indexes and storage structures used. Only one schema per database. Mappings: The DBMS is responsible for mapping between these three types of schema:            The DBMS must confirm that each external schema is derivable from the conceptual schema, and it must use the information in the conceptual schema to map between each external schema and the internal schema  Types of mappings: conceptual/internal mapping. External/conceptual mapping. Conceptual/Internal mapping:      Enables DBMS to: To fi...
Post a Comment
Read more