01ce0302 Database Management System 1
01ce0302 Database Management System 1
01ce0302 Database Management System 1
B.Tech. Year - II
Objective:
A major purpose of a database system is to provide users with an abstract view of the
data. The lowest level of abstraction, the physical level, describes how the data are
actually stored. The next-higher level of abstraction, the logical level, describes what
data are stored, and what relationships exist among those data. The highest level of
abstraction, the view level, describes parts of the database that are relevant to each
user; application programs used to access a database form part of the view level. The
SQL will help the user to retrieve the data from the database as per the requirement.
Course Outcomes: After learning the course, the students should be able:
• Use Relational Database and different models of Database. (Apply)
• Design ER Model for an Application. (Create)
• Apply Concepts of normalization with functional dependency to construct Data
dictionary. (Apply)
• Implement Structured Query Language (SQL) and evaluate query expression.
(Evaluate)
• Differentiate and Execute transactional Concepts and locking mechanism
(Analyze)
• Use concepts of Database Security on Database. (Apply)
Tutorial/ Practical
Teaching Scheme (Hours) Theory Marks
Marks
Total
Credits Mid Term
ESE Internal Marks
Theory Tutorial Practical Sem Viva (V) work
(E) (I)
(M) (TW)
4 0 2 5 50 30 20 25 25 150
Syllabus for Bachelor of Technology
References:
Syllabus for Bachelor of Technology
acc_no varchar2 5
Name varchar2 30
City varchar2 20
Balance Number 10,2
loan_taken varchar2 5
Insert the following records.
acc_no Name City Balance loan_taken
A001 Patel Jigar Mehsana 50000 YES
A002 Patel Ramesh Mehsana 50000 YES
A003 Dave Hardik Ahmedabad 75000 NO
A004 Soni Hetal Ahmedabad 100000 NO
A005 Sony Atul Vadodara 100000 YES
Syllabus for Bachelor of Technology
Supplementary Resources:
1. https://apex.oracle.com/en/
2. https://ilearning.oracle.com/
3. https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/about