Open International Journal of Informatics

Running head: Database
DATABASE
Name of the Student
Name of the University
Author Note

Database
1
Table of Contents
Task 1:........................................................................................................................................2
Task 2:........................................................................................................................................5
Task 3:........................................................................................................................................8
Task 4:........................................................................................................................................9
Task 5:......................................................................................................................................10
Task 6:......................................................................................................................................10
Task 7:......................................................................................................................................12
Bibliography:............................................................................................................................14

Database
2
Task 1:
create table Branch(
branchNumber text(3) primary key,
branchName text,streetNo text,
streetname text, branchstate text,
numberEmployees integer
);
create table publisher (
publisherCode text(3) PRIMARY KEY,
publisherName text,
publisherCity text,publisherState teXT
);

Database
3
CREATE TABLE AUTHOR (
authorID text (4) PRIMARY KEY,
firstName text, lastName text
);
CREATE TABLE book (
ISBN text(10) PRIMARY KEY,
title text(20) NOT NULL,
publishercode text(3),
genre text,
retailprice INTEGER,