Question

Create a table tHW2_1_xxxx with the following fields and their data types (id:int, auto increment, Name: varchar(10), birthday: date, annual_salary: float, bno: varchar(8)), where id is primary key and bno is a foreign key to the branchno column of Branch table in the dreamhome database. All fields cannot be null. then insert five records into your tHW2_1_xxxx table. All the name, birthday, should be different.

Answer 1

Answer)
create table tHW2_1_xxxx (id int AUTOINCREMENT not null,
Name varchar(10) not null, birthday date not null, annual_salary float not null, bno varchar(8)) not null, FOREIGN KEY (bno) REFERENCES Branch(branchno));

INSERT INTO tHW2_1_xxxx (Name, birthday, annual_salary, bno)
VALUES ( 'Paul', '2008-11-11', 20000, 1);

INSERT INTO tHW2_1_xxxx (Name, birthday, annual_salary, bno)
VALUES ( 'John', '2001-10-12', 40000, 2);

INSERT INTO tHW2_1_xxxx (Name, birthday, annual_salary, bno)
VALUES ( 'Siya', '1989-09-13', 60000, 3);

INSERT INTO tHW2_1_xxxx (Name, birthday, annual_salary, bno)
VALUES ( 'Hero', '1995-08-14', 80000, 1);

INSERT INTO tHW2_1_xxxx (Name, birthday, annual_salary, bno)
VALUES ( 'Iker', '1991-07-15', 40000, 12);