EXERCISE 6

1. Create database sch system
2. Create table course 
(id char (36)) not null,
Course_code char(10),
Course_description varchar(30),
Outline text,
Std_price double);

3. create table student
(id char(30)not null,
l_name varchar(20)not null,
f_name varchar(20),
m_name varchar(20));

4. create table sale

Id char(36) not null,
Sale_date Datetime not null,
Student_id char(36) not null,
Course_id char(36) not null,
Price_sold double;

5.	run the statements one at a time

describe course;
describe student;
describe sale;

exercise 7

(primary key, uuid() functions alter table and create unique key

1.	run select uuid(); several times
question what was the results of each num
2.	select length ((uuid());
3.	alter table course
add constraint pk_course
primary key(id);
4.	insert into course
(id, course_code, course description outlin)
Values (uuid(), ‘MS p65’, ‘sq’ ‘this is the outline’);
Insert into course 
(uuid(), ‘mysq6’, adu sql’, this is the outline’,6);

5.	on your own set primary keys for table student and sales  both of which are to be based on the field id.