logo

Open International Journal of Informatics

   

Added on  2022-08-24

15 Pages1431 Words23 Views
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,

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
DATABASE SYSTEMS INFORMATION 2022
|8
|666
|22

Database Implementation: ER Diagram, Tables, and Queries
|19
|1655
|417

Database Fundamentals: ER Diagram, Tables, and Queries
|26
|2044
|65

Database Implementation for PartyKids
|21
|1513
|397

Assignment on Basic Database Concepts
|8
|548
|58

Database Prototype Designs
|17
|1005
|25