a) Create a table bank_details Column Name Datatype Constraint Not Null Varchar2(4) number(4) Recurrent_acno аc no Transaction_date Fixed_deposit date Number(8)

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Only answer for a
a) Create a table bank_details
Column Name
Datatype
Varchar2(4)
Constraint
Recurrent_acno
Not Null
number(4)
date
ac_no
Transaction_date
Fixed_deposit
Number(8)
b) Insert the records using the following table values
Recurrent_acno ac_no
Transaction_date
Fixed_deposit
C101
101
12.05.2002
10000
C102
102
13.01.2020
80000
C103
103
14.02.2021
50000
C101
104
13.05.2020
40000
C102
105
15.06.2019
null
Transcribed Image Text:a) Create a table bank_details Column Name Datatype Varchar2(4) Constraint Recurrent_acno Not Null number(4) date ac_no Transaction_date Fixed_deposit Number(8) b) Insert the records using the following table values Recurrent_acno ac_no Transaction_date Fixed_deposit C101 101 12.05.2002 10000 C102 102 13.01.2020 80000 C103 103 14.02.2021 50000 C101 104 13.05.2020 40000 C102 105 15.06.2019 null
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Fundamentals of Boolean Algebra and Digital Logics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education