Scribd
Upload
90 views

Create Database ABC

The document creates a database called ABC_College and defines three tables: student, course, and grade_report. It inserts data into the tables and runs queries to select, update, and backup the database.

Uploaded by

mekuriaw
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
90 views

Create Database ABC

The document creates a database called ABC_College and defines three tables: student, course, and grade_report. It inserts data into the tables and runs queries to select, update, and backup the database.

Uploaded by

mekuriaw
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

create database ABC_College

use ABC_College
create table student
(
studid varchar(10)primary key,
name char(30)not null,
sex char(6)default'female'check(sex='male'or sex='female'),
birthdate datetime not null,
section char(6),
deptName char(40)
)
create table COURSE
(
course_code varchar(8)primary key,
course_title char(40)not null,
credit int
)
create table grade_report
(
studid varchar(10),
course_code varchar(8),
grade char(6)check(grade in('A','B','C','D','F')),
primary key(studid,course_code),
foreign key(studid)references student(studid),
foreign key(course_code)references course(course_code)
)
alter table student
add EmailAaaress char(25)
select*from student
select*from course
select*from grade_report
insert into student
values('R101','Kiros','male','10/02/80','Room1','computer','Kiros
@gmail.com')
insert into student
values('R102','mulu','female','12/06/78','Room1','computer','alem
u@yahoo.com')
insert into student
values('R103','Getachew','male','11/01/70','Room2','Electrical','
gechew@yahoo.com')
insert into student
values('R104','Melkamu','male','10/09/73','Room1','computer','Mlk
amu@gmail.com')
insert into student
values('R105','seble','femal','10/01/79','Room2','Electrical','se
ble@gmail.com')
insert into course values('ict001','calculus',80)
insert into course values('ict002','software',140)
insert into course values('Elec003','Electrical',200)
insert into grade_report values('R101','ict001','B')
insert into grade_report values('R101','ict002','C')
insert into grade_report values('R102','ict001','A')
insert into grade_report values('R103','Elec003','C')
insert into grade_report values('R104','ict001','B')
insert into grade_report values('R104','ict002','A')
insert into grade_report values('R105','Elec','B')
1 select student.name from student
where student.studid in(select grade_report.studid from
grade_report
where grade_report.grade='B')
2 select student.studid,student.name from
student,grade_report,course
where student.studid=grade_report.studid and
grade_report.course_code=course.course_code and
course.course_title='software'
3 select*from student
where student.deptname='computer' and
student.studid in(select grade_report.studid from grade_report
where grade_report.grade='A')order by student.deptname
desc,student.name asc
4 backup database ABC_College to
disk='D:\senayt\ABC_College.back'
5 update student set section='room4'
where student.studid in(select grade_report.studid from
grade_report,course
where grade_report.course_code=course.course_code
and course.course_title='software'
and grade_report.grade in('A','B'))
6 drop database ABC_College
restore database ABC_College from
disk='D:\senayt\ABC_College.back'

You might also like