Skip to main content

RDBMS Data Definition Language | Create Buses table

Image
By Astrio Jather

 efer 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


 


efer 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

 
Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+

 
Result Description
 Summary of tests
+------------------------------+
| 3 tests run / 3 test passed  |
+------------------------------+


Labels:

Comments

Post a Comment

Must Read:

Software Engineering Concepts Software Engineering Fundamentals Post-Quiz

By Astrio Jather
  Software Engineering Concepts       Software Engineering Fundamentals            Post-Quiz
Post a Comment
Read more

RDBMS Data Definition Language | Alter - Add CHECK constraint to Mobile_Master

By Astrio Jather
RDBMS  Data Definition Language  Alter - Add CHECK constraint to Mobile_Master Refer the following schema and add a constraint CHK_WARRANTY in Mobile_Master table to ensure that the warranty in years is greater than zero. Evaluation Result: Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+
Post a Comment
Read more

RDBMS Data Definition Language | Alter - Establish Referential Integrity Constraint

By Astrio Jather
RDBMS  Data Definition Language  Alter - Establish Referential Integrity Constraint Identify the common key between the customer_info and Sales_info tables and establish referential integrity constraint between them. Give the constraint name as FK_KEY. Evaluation Result: Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+
Post a Comment
Read more

Mock 3 Slot3 - Quiz - 21st July Quiz Quiz

By Astrio Jather
Mock 3 Slot3        Quiz - 21st July          Important Questions
Post a Comment
Read more

Number Pattern

By Astrio Jather
  /* @ToDo     Number Pattern                 1                    1       2                1       2       3            1       2       3       4        1       2       3       4       5            */ #include   <iost...
Post a Comment
Read more

Subscribe to Get's Answer by Email