KEMBAR78
Database Table Design Guide | PDF
Scribd
Upload
368 views2 pages

Database Table Design Guide

1. Create a Student table with columns for SID, SNAME, ADDRESS, AGE, and ROLLNO. Alter the table to add constraints like NOT NULL for SNAME, minimum age of 3, unique ROLLNO, default age of 4, add and then drop a CONTACTNO column, and drop the age constraint. 2. Create Book, Member, and Transaction tables with columns for book details, member details, and book transactions. Alter the tables to add PRIMARY KEY and FOREIGN KEY constraints between the tables. 3. Add a PUBLICATION column to the Book table and a MEMBERTYPE column to the Member table. Rename the PRICE column in Book to BO

Uploaded by

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

Database Table Design Guide

1. Create a Student table with columns for SID, SNAME, ADDRESS, AGE, and ROLLNO. Alter the table to add constraints like NOT NULL for SNAME, minimum age of 3, unique ROLLNO, default age of 4, add and then drop a CONTACTNO column, and drop the age constraint. 2. Create Book, Member, and Transaction tables with columns for book details, member details, and book transactions. Alter the tables to add PRIMARY KEY and FOREIGN KEY constraints between the tables. 3. Add a PUBLICATION column to the Book table and a MEMBERTYPE column to the Member table. Rename the PRICE column in Book to BO

Uploaded by

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

DDL Assignments

1.
Create Student table with

Column Name Data type Size Constraint


SID NUMBER 5 Primary key
SNAME VARCHAR 30
ADDRESS VARCHAR 50
AGE NUMBER 2
ROLLNO VARCHAR 10

1. Create the above table


2. Alter the table to
1. Not null for sname,
2. Age can be only above 3,
3. Rollno unique
4. Default age 4
5. Add a new column contactno number
6. Drop the constraint check on the age column
7. Drop the column contactno

2.

Book

Column Datatype Constraint


BOOKID NUMBER PRIMARY KEY
BOOKNAME VARCHAR NOT NULL
AUTHOR VARCHAR
EDITION NUMBER DEFAULT 2
PRICE NUMBER

Member

COLUMN DATATYPE CONSTRAINT


MID NUMBER PRIMARY KEY
MNAME VARCHAR NOT NULL
MAILID VARCHAR
ADDRESS VARCHAR
Transaction

COLUMN DATATYPE CONSTRAINT


BID NUMBER FOREIGN KEY , PRIMARY KEY
MID NUMBER FOREIGN KEY , PRIMARY KEY
ISSUEDATE DATE DEFAULT SYSDATE
RETURN DATE DATE

1. Create the above tables without any constraints


2. Alter the table to add the above constraints
3. Add a new column called publication in book table.
4. Add a new column called membertype, which can be either student or faculty in the
member table
5. Rename the column price as bookprice in book table

You might also like