Create Buses table program in SQL

Question:

Create Buses table

Refer the below schema and create the buses table.

Column Name Datatype Size Constraint Constraint name
Bus_no Number 11 Primary key PK_BUSES
Bus_name Varchar2 20    
Type Varchar2 20    
Total_seats Number 11    
Avail_seats Number 11
create table buses(
	Bus_no number(11),
  	Bus_name varchar2(20),
  	Type varchar2(20),
  	Total_seats number(11),
  	Avail_seats number(30),
  	constraint PK_BUSES primary key(Bus_no)
);

rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program

Leave a Comment

Scroll to Top