HomeworkLib
Question

CREATE TABLE HOUSE    (HouseAddress CHAR(50),    HouseOwner CHAR(30),    Insurance CHAR(40),       CREATE TABLE...

CREATE TABLE HOUSE
   (HouseAddress CHAR(50),
   HouseOwner CHAR(30),
   Insurance CHAR(40),
     
CREATE TABLE HEATINGUNIT
   (HeatingUnitID INT,
   UnitName CHAR(30),
   UnitType CHAR(40),
   Manufactory CHAR(40),
   DataOfBuilt Date,
   Capacity INT,
   HouseAddress CHAR(50));

CREATE TABLE TECHNICIAN
   (EmployeeNumber INT,
   EmployeeName CHAR(30),
   Title CHAR(40),
   YearHired INT);
     
  
CREATE TABLE SERVICE
   (HeatingUnitID INT,
   ServiceType CHAR(40),
   Date Date,
   Time TIMESTAMP
   EmployeeNumber INT);
  
INSERT INTO SERVICE
   VALUES ('Repair', NULL, NULL, 1),
('Repair', NULL, NULL, 2),
('Upgrade', NULL, NULL, 2),
       ('Upgrade', NULL, NULL, 2);
         

INSERT INTO HOUSE
   VALUES ('123 Pelham', 'Macy', 'Yes'),
('321 Sesame St', 'Mary', 'Yes'),
('456 MLK ', 'Marcy', 'No'),
       ('654 Peter Way', 'Maria', 'No'),
       ('789 Ava', 'Madison', 'Yes'),
       ('987 Davon Crt', 'Madison', 'Yes'),;
         
         
  
INSERT INTO HEATINGUNIT
   VALUES (1, 'Xlarge', 'Popane', "MayFlower", NULL, 2000, ' 123 Pelham'),
       (2, 'Smedium', 'Hydro', "LG", NULL, 3000, ' 321 Sesame St'),
       (4, 'Large', 'Solar', "WhirlPool", NULL, 5000, ' 456 MLK '),
       (3, 'Small', 'Electric', "Amana", NULL, 3500, ' 654 Peter Way'),
       (5, 'Small', 'Gas', "Smud", NULL, 2500, ' 789 Ava'),
       (6, 'Xlarge', 'Hydro', "Boscj", NULL, 1500, ' 987 Davon Crt'),
  
INSERT INTO TECHNICIAN
   VALUES ('Peter', 'Mechanic', '2014'),
       ('Pierre', 'Installer', '2016'),
       ('Pedro', 'Tech', '2005'),
       ('Pita', 'Supervisor',2001'),;

how do i fix?

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE HEATINGUNIT (HeatingUnitID INT, UnitName CHAR(30), UnitType CH' at line 6

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

The above error is because you have ended the body of

CREATE TABLE HOUSE
   (HouseAddress CHAR(50),
   HouseOwner CHAR(30),
   Insurance CHAR(40),

that is it will be

CREATE TABLE HOUSE
   (HouseAddress CHAR(50),
   HouseOwner CHAR(30),
   Insurance CHAR(40) );

However there are also other errors in your program other than this.

You have done similar mistakes in the INSERT queries as well.

Please upvote if you find the answer helpful.

0 0
Add a comment
Know the answer?
Add Answer to:
CREATE TABLE HOUSE    (HouseAddress CHAR(50),    HouseOwner CHAR(30),    Insurance CHAR(40),       CREATE TABLE...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • In the table SERVICE there is an EmployeeNumber attribute. This number is a secondary key in...

    In the table SERVICE there is an EmployeeNumber attribute. This number is a secondary key in the SERVICE table but is a primary key in the TECHNICIAN table. Create a query that shows a list of service types, the date (can be just the year) the service was performed, and the name of the technician that performed the service. Order by employee name and then by date per employee name. CREATE TABLE HOUSE (HouseAddress CHAR(50), HouseOwner CHAR(30), Insurance CHAR(40)); INSERT...

  • Relation Students has schema: CREATE TABLE Students (     BannerID CHAR(9),     stuName VARCHAR(40) NOT NULL,...

    Relation Students has schema: CREATE TABLE Students (     BannerID CHAR(9),     stuName VARCHAR(40) NOT NULL,     scholarship INT,     PRIMARY KEY(BannerID)); The relation Students is currently empty. Develop a test that determines whether an insertion into Students is currently legal. Then apply your test to determine which of the following INSERT statements is allowable.             a. INSERT INTO Students VALUES(950111333, ’John Smith’, 1000); b. INSERT INTO Students (BannerID, stuName) VALUES(‘950111333’, ’John Smith’); c. INSERT INTO Students VALUES(‘950111222’, NOT NULL,...

  • Database Management 6. [5] Create the following table: CREATE TABLE customer ( cust_name VARCHAR(30) NOT NULL,...

    Database Management 6. [5] Create the following table: CREATE TABLE customer ( cust_name VARCHAR(30) NOT NULL, address VARCHAR(60), UNIQUE (cust name, address)); A. Run the following inserts and explain why both work and how will you prevent it INSERT INTO customer VALUES ('Alex Doe', NULL); INSERT INTO customer VALUES ('Alex Doe', NULL); 7. [5] Modify the following table definition to ensure that all employees have a minimum wage of $10 CREATE TABLE employee ( empId INT PRIMARY KEY, empName VARCHAR(40)...

  • SQL I have a database CREATE TABLE vendor ( vid CHAR(2) NOT NULL, vname VARCHAR(25) NOT...

    SQL I have a database CREATE TABLE vendor ( vid CHAR(2) NOT NULL, vname VARCHAR(25) NOT NULL, PRIMARY KEY (vid) ); CREATE TABLE category ( catid CHAR(2) NOT NULL, catname VARCHAR(25) NOT NULL, PRIMARY KEY (catid) ); CREATE TABLE product ( pid CHAR(3) NOT NULL, pname VARCHAR(25) NOT NULL, price NUMERIC (7,2) NOT NULL, vid CHAR(2) NOT NULL, categoryid CHAR(2) NOT NULL, PRIMARY KEY (pid)); CREATE TABLE region ( rid CHAR NOT NULL, rname VARCHAR(25) NOT NULL, PRIMARY KEY (rid)...

  • CREATE TABLE vendor ( vendor_id int NOT NULL, vendor_name char(50) NOT NULL, contact_name char(50), CONSTRAINT vendors_pk...

    CREATE TABLE vendor ( vendor_id int NOT NULL, vendor_name char(50) NOT NULL, contact_name char(50), CONSTRAINT vendors_pk PRIMARY KEY (vendor_id) ); What is the code to add the foreign key for this table? Can you please add the entire code with mine included. Thank you in advance.

  • USE colonial; CREATE TABLE CUSTOMER (CUSTOMER_NUM CHAR(4) PRIMARY KEY, LAST_NAME CHAR(30) NOT NULL, FIRST_NAME CHAR (30),...

    USE colonial; CREATE TABLE CUSTOMER (CUSTOMER_NUM CHAR(4) PRIMARY KEY, LAST_NAME CHAR(30) NOT NULL, FIRST_NAME CHAR (30), ADDRESS CHAR(35), CITY CHAR(35), STATE CHAR(2), POSTAL_CODE CHAR(5), PHONE CHAR(12) ); CREATE TABLE RESERVATION (RESERVATION_ID CHAR(7) PRIMARY KEY, TRIP_ID DECIMAL(3,0), TRIP_DATE DATE, NUM_PERSONS DECIMAL(3,0), TRIP_PRICE DECIMAL(6,2), OTHER_FEES DECIMAL(6,2), CUSTOMER_NUM CHAR(4) ); CREATE TABLE TRIP (TRIP_ID DECIMAL(3,0) PRIMARY KEY, TRIP_NAME CHAR(75), START_LOCATION CHAR(50), STATE CHAR(2), DISTANCE DECIMAL(4,0), MAX_GRP_SIZE DECIMAL(4,0), TYPE CHAR(20), SEASON CHAR(20) ); CREATE TABLE TRIP_GUIDES (TRIP_ID DECIMAL(3,0), GUIDE_NUM CHAR(4), PRIMARY KEY (TRIP_ID, GUIDE_NUM)...

  • USE colonial; CREATE TABLE CUSTOMER (CUSTOMER_NUM CHAR(4) PRIMARY KEY, LAST_NAME CHAR(30) NOT NULL, FIRST_NAME CHAR (30),...

    USE colonial; CREATE TABLE CUSTOMER (CUSTOMER_NUM CHAR(4) PRIMARY KEY, LAST_NAME CHAR(30) NOT NULL, FIRST_NAME CHAR (30), ADDRESS CHAR(35), CITY CHAR(35), STATE CHAR(2), POSTAL_CODE CHAR(5), PHONE CHAR(12) ); CREATE TABLE RESERVATION (RESERVATION_ID CHAR(7) PRIMARY KEY, TRIP_ID DECIMAL(3,0), TRIP_DATE DATE, NUM_PERSONS DECIMAL(3,0), TRIP_PRICE DECIMAL(6,2), OTHER_FEES DECIMAL(6,2), CUSTOMER_NUM CHAR(4) ); CREATE TABLE TRIP (TRIP_ID DECIMAL(3,0) PRIMARY KEY, TRIP_NAME CHAR(75), START_LOCATION CHAR(50), STATE CHAR(2), DISTANCE DECIMAL(4,0), MAX_GRP_SIZE DECIMAL(4,0), TYPE CHAR(20), SEASON CHAR(20) ); CREATE TABLE TRIP_GUIDES (TRIP_ID DECIMAL(3,0), GUIDE_NUM CHAR(4), PRIMARY KEY (TRIP_ID, GUIDE_NUM)...

  • drop table department cascade constraints; create table department ( Dname   varchar2(15)   not null, Dnumber int   not...

    drop table department cascade constraints; create table department ( Dname   varchar2(15)   not null, Dnumber int   not null, Mgr_ssn   char(9)   not null, mgr_start_date   Date, primary key (Dnumber), Unique    (Dname)); insert into DEPARTMENT values ('Research', '5', '333445555', '22-May-1988'); insert into DEPARTMENT values ('Administration', '4', '987654321', '01-Jan-1995'); insert into DEPARTMENT values ('Headquarters', '1', '888665555', '19-Jun-1981'); drop table employee cascade constraints; create table employee ( Fname   varchar2(15) not null, Minit   char(1), Lname   varchar2(15) not null, Ssn   char(9), Bdate   date, Address   varchar2(30), Sex   char(1),...

  • CREATE TABLE Bill( bill_id char(15) PRIMARY KEY, bill_name VARCHAR(150) NOT NULL, dateOfVoteCommittee date, dateOfVote date, isPassed...

    CREATE TABLE Bill( bill_id char(15) PRIMARY KEY, bill_name VARCHAR(150) NOT NULL, dateOfVoteCommittee date, dateOfVote date, isPassed tinyint(1) CHECK (isPassed IN (0,1)), date_signed date, isVeto tinyint(1) CHECK (isVeto IN (0,1)), dateOfVote_override date, proposed_person_id INT, committee_id INT, foreign key(proposed_person_id) REFERENCES Congressman(person_id), foreign key(committee_id) REFERENCES Committee(committee_id) ); INSERT INTO Bill (bill_id, bill_name, dateOfVote, isPassed, date_signed, isVeto, dateOfVote_override, proposed_person_id, commitee_id) VALUES(1,'SB2 Florida Statutes',DATE'2019-03-27',1,DATE'2019-03-27',0,23,);   *I am getting this error - mysql Mysql doesn't like the date entries in the insert statement. Schema above for reference.

  • CREATE TABLE GLAccounts (    AccountNo INT,    AccountDescription VARCHAR(50),    --    CONSTRAINT GLAccounts_PK PRIMARY...

    CREATE TABLE GLAccounts (    AccountNo INT,    AccountDescription VARCHAR(50),    --    CONSTRAINT GLAccounts_PK PRIMARY KEY(AccountNo),    --    CONSTRAINT AccountDescription_NULL CHECK(AccountDescription IS NOT NULL),    --    CONSTRAINT AccountDescription_Zero_LEN CHECK(LEN(AccountDescription)>0) ); GO ----------------------------------------------------------------------------- CREATE TABLE Terms (    TermsID INT,    TermsDescription VARCHAR(50),    TermsDueDays SMALLINT,    --    CONSTRAINT PK_Terms PRIMARY KEY(TermsID),    --    CONSTRAINT TermsDescription_NULL    CHECK(TermsDescription IS NOT NULL),    CONSTRAINT TermsDueDays_NULL        CHECK(TermsDueDays IS NOT NULL),    --    CONSTRAINT TermsDescription_zero_LEN   ...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT