Database System

Course Discription

Introduction of Database System, Characteristics & Advantages of DBMS, Structure of Databases, Data Independency, Classification of DBMS, Database Languages, views, Triggers, Transaction Management, Abstraction in DBMS, Database Models, Entity and Entity Set, Naming Conventions & Design Issues in ER Model. ER Diagrams. Relational Database Models. Domains, Attributes, Integrity Constraints, Relational Algebra Operations. Transaction Processing Concepts. Functional Dependencies, Normalization. Characteristics & Advantage of SQL, SQL Data Types, Literals, Commands, Operators. Tables, Views, Indexes, Queries and sub queries, Aggregate functions, Clauses, Concurrency Control, Database Security.

Course Goals and Objectives

1

Discuss about how to deal with database, understanding and analyzing the data.

2

Understand how to write and modify SQL query.

3

Encourage the students to discuss during lecture to obtain in-depth knowledge of database.

4

To teach students how to access the database and understand the data models.

5

Deals with the creation of ER Diagrams and its applications.

Course Outcomes

1

a) An ability to select and apply the knowledge, techniques, skills, and modern tools of their disciplines to broadly-defined engineering technology activities

2

b)  An ability to select and apply knowledge of mathematics, science, engineering, and technology to engineering technology problems that require the application of principles and applied procedures or methodologies

3

c) An ability to design systems, components, or processes for broadly-defined engineering technology problems appropriate to program educational objectives

4

d) An ability to conduct standard tests and measurements; to conduct, analyze, and interpret experiments; and to apply experimental results to improve processes

5

e) An ability to function effectively as a member or leader on a technical team

6

f) An ability to identify, analyze, and solve broadly-defined engineering technology problems

7

h) An understanding of the need for and an ability to engage in self-directed continuing professional development


الملفات المرفقة

  • Lecture 1 (Database Lecture 1.pdf - B)
  • Lecture 2 (Database System- 216 Lecture2.pdf - B)

الساعات المكتبية

Sunday 10-12

Monday 9-10

Thursday 8-10

Final Exam

Final Exam

Starting soon...

Notice

Quiz Marks for IT 321 and IT 311 are displayed on Department Notice Board



Project

  • Human Resource Development Group: http://csirhrdg.res.in
  • Laxmi Devi Institute of Engineering and Technology: http://liet.org
  • Knowledge mapping System: Knowledge Repository
  • PaperLess Meeting Portal for Majmaah University college of Engineering
  • Employee Attendance System for Majmaah University

Seminar Conducted

  • AJAX and JSON: A New Approach to Web Applications
  • Knowledge Mapping System
  • Cloud Based CMS for Developers


Calendar



أرقام الاتصال

Ahsan Ahmed

Tel: 164046737 Ex. 6737

Fax: 064322785

[email protected]

Google


Calendar

إحصائية الموقع

عدد الصفحات: 29

البحوث والمحاضرات: 23

الزيارات: 7011