course outline isys6169 database systems …course outline fm - binus - aa - fpa - 27/r0...
TRANSCRIPT
FM - BINUS - AA - FPA - 27/R0
Course Outline
ISYS6169 Database Systems (CYSEC) (4/2)
Study Program Information Systems
Effective Date 01 February 2018 Revision 2
1. Course Description
This course introduces concept and terminology in database like database architecture, relational model, Structured Query Language, database design, technologies and issues in database environment. It gives student basic knowledge about database system. It is prerequisite for Database Design course.
2. Graduate Competency
Each course in the study program contributes to the graduate competencies that are divided into employability and entrepreneurial skills and study program specific outcomes, in which students need to have demonstrated by the time they complete their course. BINUS University employability and entrepreneurial skills consist of planning and organizing, problem solving and decision making, self management, team work, communication, and initiative and enterprise. 2.1. Employability and Entrepreneurial Skills
Aspect Key Behaviour
2.2. Study Program Specific Outcomes
Study Program Specific Outcomes
(SO-1) - Able to create software application design with the implementation of database system principal design to solve structured and semi-structured data
(SO-3) able to assess technology trend in informatics area to deliver alternative solution of software development
3. Topics
• Introduction To Database • Database Environment • Database Architectures and the Web • The Relational Model • Relational Algebra and Relational Calculus • SQL - Data Definition and Data Manipulation (1) • Security and Administration • SQL - Data Definition and Data Manipulation (2) • Advanced SQL • Transaction Management • Database System Development Lifecycle • Database Analysis • Normalization • Advanced Normalization • Distributed DBMS-Concept and Design • Entity Relationship (ER) Modelling • Enhanced Entity Relationship (ER) Modelling • Data Warehousing Concepts • Data Mining
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 2
Study Program Information Systems - Bina Nusantara University
• Database Environment • SQL – Data Definition (1) • SQL – Data Manipulation (1) • SQL – Data Manipulation (2) • SQL – Data Manipulation (3) • SQL – Data Manipulation (4) • SQL – Data Manipulation (5) • SQL –Data Definition (2) • Advanced SQL • Normalization & Entity Relationship (ER) Modelling • Review & Project Submission
4. Learning Outcomes
On successful completion of this course, student will be able to: • LO 1: Describe database systems, terminology, environment, and new concept of database • LO 2: Apply database language and SQL Programming language • LO 3: Design database using structure data model • LO 4: Evaluate database processing and security Mechanism
5. Teaching And Learning Strategies
In this course, the lecturers might deploy several teaching learning strategies, including Presentation, Demonstration, Case Study, and Lecture.
6. Textbooks and Other Resources 6.1 Textbooks
1. Thomas Connolly and Carolyn Begg. (2015). Database Systems: A Practical Approach To Design, Implementation, and Management. 06. Pearson Education. USA. ISBN: 9781292061184.
The book in the first list is a must to have for each student.
6.2 Other Resources
1. Digital Content - CREATE TABLE SYNTAX Examples 2. http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql 3. http://www.bytes.com/topic/access/insights/585228-database-normalization-table-structures 4. http://www.cs.sfu.ca/CourseCentral/354/jpei/slides/RelationalCalculus.pdf 5. http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/in-transact-sql 6. http://www.docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql 7. http://www.wofford-ecs.org/DataAndVisualization/ermodel/material.htm 8. http://www.javaexchange.com/dcb_white.html 9. http://www.home.kku.ac.th/wichuda/Sa/Slide/MIT/MIT_C2Fact.pdf 10. http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql 11. http://www.red-gate.com/simple-talk/sql/database-administration/sql-server-security-cribsheet/ 12. http://www.tinman.cs.gsu.edu/~raj/4710/f11/Ch08.pdf 13. http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/all-transact-sql 14. http://www.beginnersbook..com/2015/05/normalization-in-dbms/ 15. http://www.wofford-ecs.org/DataAndVisualization/ermodel/material.htm 16. http://www.cs.ucc.ie/pipermail/cs2501/attachments/20091015/a1d4fcea/attachment-0004.pdf 17. http://www.brentozar.com/sql/sql-server-performance-tuning/ 18. http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/some-any-transact-sql 19. http://www.docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch21.htm 20. http://www.docs.microsoft.com/en-us/sql/t-sql/statements/statements 21. http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql 22. http://www.ucl.ac.uk/archaeology/cisp/database/manual/node1.html 23. http://www.docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql 24. http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql 25. http://www.beginnersbook..com/2015/05/normalization-in-dbms/ 26. http://www.databasejournal.com/features/mssql/article.php/3771871/SQL-Server-2008-Data-Collections-
and-the-Management-Data-Warehouse.htm 27. http://www.docs.microsoft.com/en-us/sql/t-sql/queries/queries 28. http://www.docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-join 29. http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 3
Study Program Information Systems - Bina Nusantara University
30. http://www.comp.dit.ie/btierney/oracle11gdoc/server.111/b28318/transact.htm 31. http://www.scribd.com/doc/2321336/Database-Normalization 32. http://www.docs.microsoft.com/en-us/sql/t-sql/queries/queries 33. http://www.scribd.com/doc/2321336/Database-Normalization 34. http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/in-transact-sql 35. http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/exists-transact-sql 36. http://www.cs.umd.edu/class/spring2005/cmsc424-0201/DB-metho.pdf 37. http://www.docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql 38. http://www.ijmter.com/papers/volume-1/issue-3/study-of-the-ansisparc-architecture.pdf 39. http://www.inf.unibz.it/~franconi/teaching/2000/ct481/er-modelling/ 40. http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql 41. http://www.ijmter.com/papers/volume-1/issue-3/study-of-the-ansisparc-architecture.pdf 42. http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/exists-transact-sql 43. http://www.docs.microsoft.com/en-us/sql/t-sql/statements/statements 44. http://www.docstore.mik.ua/orelly/networking/puis/ch12_02.htm 45. http://www.laits.utexas.edu/~anorman/BUS.FOR/course.mat/Alex/ 46. http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/all-transact-sql 47. http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/some-any-transact-sql 48. http://www.inf.unibz.it/~franconi/teaching/2000/ct481/er-modelling/ 49. http://www.fact-index.com/r/re/relational_algebra.html 50. http://www.red-gate.com/simple-talk/sql/learn-sql-server/managing-transaction-logs-in-sql-server/ 51. http://www.docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql
7. Schedule
Theory
Session/Mode
Related LO
Topics References
1 F2F
LO 1 Introduction To Database - Points to some common uses of database
systems - Traditional File-Based Systems - Database approach - Components in the DBMS Environment - Roles in the Database Environment - History of Database Management Systems - Advantages and Disadvantages of DBMS
- Introduction to Database - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 1
- An Introduction to databases, http://www.ucl.ac.uk/archaeology/cisp/database/manual/node1.html
2 F2F
LO 1 Database Environment - Three levels database architecture - Logical and Physical data independence - Database Languages - Data Model - Function of DBMS - System catalog - DBMS components
- Database Environment - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 2
- Three levels ANSI SPARC Architecture, http://www.ijmter.com/papers/volume-1/issue-3/study-of-the-ansisparc-architecture.pdf
3 F2F
LO 1 Database Architectures and the Web - Multiuser DBMS Architectures - Web Services and Service-Oriented
Architectures - The architecture of Data Warehouse - Cloud Computing
- Database Architectures and the Web
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 3
- Multi Tier Architectures for Database Connectivity, http://www.javaexchange.com/dcb_white.html
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 4
Study Program Information Systems - Bina Nusantara University
4 F2F
LO 1 The Relational Model - Relational Model Terminology - Mathematical Definition of Relations - Database Relations - Integrity Constraints
- The Relational Model - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 4
- Relational Models, http://www.cs.ucc.ie/pipermail/cs2501/attachments/20091015/a1d4fcea/attachment-0004.pdf
5 F2F
LO 2 Relational Algebra and Relational Calculus - Relational completeness - Relational Algebra Operations - Tuple Relational Calculus - Domain Relational Calculus
- Relational Algebra and Relational Calculus
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 5
- Relational Calculus, http://www.cs.sfu.ca/CourseCentral/354/jpei/slides/RelationalCalculus.pdf
- Relational Algebra, http://www.fact-index.com/r/re/relational_algebra.html
6 F2F
LO 2 Relational Algebra and Relational Calculus - Relational completeness - Relational Algebra Operations - Tuple Relational Calculus - Domain Relational Calculus
- Relational Algebra and Relational Calculus
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 5
- Relational Calculus, http://www.cs.sfu.ca/CourseCentral/354/jpei/slides/RelationalCalculus.pdf
- Relational Algebra, http://www.fact-index.com/r/re/relational_algebra.html
7 F2F
LO 2 SQL - Data Definition and Data Manipulation (1) - Introduction to SQL - Data types - Integrity enhancement feature - Create, Alter and Drop the tables - Simple SQL Command - Sorting the Query Results - Grouping the Query Results
- SQL - Data Definition and Data Manipulation (1)
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 6&7
- Digital Content - CREATE TABLE SYNTAX Examples
- Data Definition Language, http://www.docs.microsoft.com/en-us/sql/t-sql/statements/statements
- Alter Table, http://www.docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql
- Data Manipulation Language (DML) Statements (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 5
Study Program Information Systems - Bina Nusantara University
sql/queries/queries - Aggregate Functions
(Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql
8 F2F
LO 2 SQL - Data Definition and Data Manipulation (1) - Introduction to SQL - Data types - Integrity enhancement feature - Create, Alter and Drop the tables - Simple SQL Command - Sorting the Query Results - Grouping the Query Results
- SQL - Data Definition and Data Manipulation (1)
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 6&7
- Digital Content - CREATE TABLE SYNTAX Examples
- Data Definition Language, http://www.docs.microsoft.com/en-us/sql/t-sql/statements/statements
- Alter Table, http://www.docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql
- Data Manipulation Language (DML) Statements (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/queries/queries
- Aggregate Functions (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql
9 GSLC
LO 1 LO 4
Security and Administration - The Scope of Database Security - Why Database Security is Needed - Type of Threat - Countermeasures-Computer-Based Controls - DBMS and Web Security
- Security and Administration - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 20
- SQL Server Security, http://www.red-gate.com/simple-talk/sql/database-administration/sql-server-security-cribsheet/
- Protecting Computer Hardware, http://www.docstore.mik.ua/orelly/networking/puis/ch12_02.htm
10 GSLC
LO 1 LO 4
Security and Administration - The Scope of Database Security - Why Database Security is Needed - Type of Threat - Countermeasures-Computer-Based Controls - DBMS and Web Security
- Security and Administration - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 20
- SQL Server Security, http://www.red-gate.com/simple-
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 6
Study Program Information Systems - Bina Nusantara University
talk/sql/database-administration/sql-server-security-cribsheet/
- Protecting Computer Hardware, http://www.docstore.mik.ua/orelly/networking/puis/ch12_02.htm
11 F2F
LO 2 SQL - Data Definition and Data Manipulation (2) - Multi Table Queries - Subqueries - String and Date Functions - Set Operations - Updating the Database using INSERT,
UPDATE, DELETE - Purpose of view - Creating and deleting view - Updatable views - Advantages/disadvantages of views - Access control : GRANT and REVOKE
command
- SQL - Data Definition and Data Manipulation (2)
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 6&7
- Create View (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql
- IN (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/in-transact-sql
- SOME | ANY (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/some-any-transact-sql
- EXISTS (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/exists-transact-sql
- ALL (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/all-transact-sql
12 F2F
LO 2 SQL - Data Definition and Data Manipulation (2) - Multi Table Queries - Subqueries - String and Date Functions - Set Operations - Updating the Database using INSERT,
UPDATE, DELETE - Purpose of view - Creating and deleting view - Updatable views - Advantages/disadvantages of views - Access control : GRANT and REVOKE
command
- SQL - Data Definition and Data Manipulation (2)
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 6&7
- Create View (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql
- IN (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/in-transact-sql
- SOME | ANY (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/some-any-transact-sql
- EXISTS (Transact-SQL), http://www.docs.microsoft.co
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 7
Study Program Information Systems - Bina Nusantara University
m/en-us/sql/t-sql/language-elements/exists-transact-sql
- ALL (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/all-transact-sql
13 F2F
LO 2 Advanced SQL - SQL Programming Language - SQL Cursors - Stored Procedures - Triggers
- Advanced SQL - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 8
- Create Procedure, http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql
- Create Trigger, http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql
14 F2F
LO 2 Advanced SQL - SQL Programming Language - SQL Cursors - Stored Procedures - Triggers
- Advanced SQL - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 8
- Create Procedure, http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql
- Create Trigger, http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql
15 F2F
LO 4 Transaction Management - Transaction Support - Concurrency Control - Database Recovery - Advanced Transaction Models
- Transaction Management - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 22
- Performance Tuning, http://www.brentozar.com/sql/sql-server-performance-tuning/
- Transaction Management, http://www.comp.dit.ie/btierney/oracle11gdoc/server.111/b28318/transact.htm
- Managing Transaction Logs in SQL server, http://www.red-gate.com/simple-talk/sql/learn-sql-server/managing-transaction-logs-in-sql-server/
16 F2F
LO 4 Transaction Management - Transaction Support - Concurrency Control
- Transaction Management - Database Systems: A
Practical Approach To
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 8
Study Program Information Systems - Bina Nusantara University
- Database Recovery - Advanced Transaction Models
Design, Implementation, and Management, Chapter 22
- Performance Tuning, http://www.brentozar.com/sql/sql-server-performance-tuning/
- Transaction Management, http://www.comp.dit.ie/btierney/oracle11gdoc/server.111/b28318/transact.htm
- Managing Transaction Logs in SQL server, http://www.red-gate.com/simple-talk/sql/learn-sql-server/managing-transaction-logs-in-sql-server/
17 GSLC
LO 3 Database System Development Lifecycle - Main stages of database system development
lifecycle - Main phases of Database Design - DBMS Selection - CASE tools
- Database System Development Lifecyle
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 10
- A Database Design Methodology, http://www.cs.umd.edu/class/spring2005/cmsc424-0201/DB-metho.pdf
18 GSLC
LO 3 Database Analysis - When Are Fact-Finding Techniques Used? - What Facts are Collected? - Facts-Finding Techniques - Using Fact-Finding Techniques
- Database Analysis - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 11
- Fact-Finding Techniques, http://www.home.kku.ac.th/wichuda/Sa/Slide/MIT/MIT_C2Fact.pdf
19 F2F
LO 3 Normalization - The Process of Normalization - How Normalization Supports Database Design - Data Redundancy and Update Anomalies - Functional Dependencies - First Normal Form (1NF),Second Normal Form
(2NF), and Third Normal Form (3NF) - General Definitions of 2NF and 3NF
- Normalization - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 14
- Normalization in DBMS, http://www.beginnersbook..com/2015/05/normalization-in-dbms/
- Database Normalization, http://www.scribd.com/doc/2321336/Database-Normalization
20 F2F
LO 3 Advanced Normalization - Inference Rules - Boyce-Codd Normal Form (BCNF) - 4NF, 5NF
- Advanced Normalization - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 15
- Database Normalization and Table Structures, http://www.bytes.com/topic/access/insights/585228-
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 9
Study Program Information Systems - Bina Nusantara University
database-normalization-table-structures
21 GSLC
LO 1 Distributed DBMS-Concept and Design - The need for distributed databases - The differences between distributed database
systems, distributed processing, and parallel database systems
- The advantages and disadvantages of distributed DBMSs
- An architecture for a distributed DBMS - Main issues associated with distributed
database design - Comparison criteria for distributed DBMSs
- Distributed DBMSs – Concept and Design
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 24
- Distributed Databases, http://www.docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch21.htm
22 GSLC
LO 1 Distributed DBMS-Concept and Design - The need for distributed databases - The differences between distributed database
systems, distributed processing, and parallel database systems
- The advantages and disadvantages of distributed DBMSs
- An architecture for a distributed DBMS - Main issues associated with distributed
database design - Comparison criteria for distributed DBMSs
- Distributed DBMSs – Concept and Design
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 24
- Distributed Databases, http://www.docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch21.htm
23 F2F
LO 3 Entity Relationship (ER) Modelling - Basic concepts in ER Modelling - Diagrammatic technique for displaying ER
model using Unified Modelling Language (UML) - Problems with ER Models
- Entity Relationship (ER) Modelling
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 12
- Entity Relationship (ER) Modelling, http://www.wofford-ecs.org/DataAndVisualization/ermodel/material.htm
- Entity Relationship (ER) Modelling, http://www.inf.unibz.it/~franconi/teaching/2000/ct481/er-modelling/
24 F2F
LO 3 Enhanced Entity Relationship (ER) Modelling - Generalization/ Specialization - Aggregation - Composition
- Enhanced Entity-Relationship Modelling
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 13
- Enhanced Entity-Relationship Modelling, http://www.tinman.cs.gsu.edu/~raj/4710/f11/Ch08.pdf
25 F2F
LO 1 Data Warehousing Concepts - How data warehousing evolved - The main concepts and benefits associated with
data warehousing - The architecture and main components of a
data warehouse - The problems associated with data warehousing - Main tools and technologies associated with
data warehousing
- Data Warehousing Concepts - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 31
- SQL Server 2008 Data Collections and the Management Data Warehouse, http://www.databasejournal.c
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 10
Study Program Information Systems - Bina Nusantara University
om/features/mssql/article.php/3771871/SQL-Server-2008-Data-Collections-and-the-Management-Data-Warehouse.htm
26 F2F
LO 1 Data Mining - Concept associated with data mining - Main features of data mining operations - Techniques associated with data mining
operations - Process of data mining - Important characteristics of data mining tools - Relationship between data mining and data
warehousing
- Data Mining - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 34
- Data Mining, http://www.laits.utexas.edu/~anorman/BUS.FOR/course.mat/Alex/
Practicum
Session/Mode
Related LO
Topics References
1 F2F
LO 1 Database Environment - Introduction general environment of SQL Server - New Server Registration & New Group - Diagram - Attach Database - Import & Export Data - Generate SQL Script - Execution SQL Statement
- Database Environment - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 2
- Three levels ANSI SPARC Architecture, http://www.ijmter.com/papers/volume-1/issue-3/study-of-the-ansisparc-architecture.pdf
2 F2F
LO 2 SQL – Data Definition (1) - Introducing table and referential integrity - Primary and Foreign Key - Constraint Value - Drop Table - Alter Table
- SQL – Data Definition (1) - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 7
- Data Definition Language, http://www.docs.microsoft.com/en-us/sql/t-sql/statements/statements
3 F2F
LO 2 SQL – Data Manipulation (1) - Insert Data - Delete Data - Update Data - Begin Trans - Simple Query - Order By
- SQL – Data Manipulation (1) - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 6
- Data Manipulation Language (DML) Statements (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/queries/queries
4 F2F
LO 2 SQL – Data Manipulation (2) - Aggregate Functions - Grouping - Compute
- SQL – Data Manipulation (2) - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 6
- Aggregate Functions (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 11
Study Program Information Systems - Bina Nusantara University
5 F2F
LO 2 SQL – Data Manipulation (3) - Quiz - String and Date Functions
- SQL – Data Manipulation (3) - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 6
- CAST and CONVERT (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql
6 F2F
LO 2 SQL – Data Manipulation (4) - Inner Join - Outer Join (LEFT JOIN, RIGHT JOIN, FULL
JOIN) - UNION, INTERSECT, DIFFERENCE
- SQL – Data Manipulation (4) - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 6
- Join in SQL Server, http://www.docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-join
7 F2F
LO 2 SQL – Data Manipulation (5) - Subquery - Alias subquery - IN & EXISTS - ANY, SOME, ALL
- SQL – Data Manipulation (5) - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 6
- ALL (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/all-transact-sql
- IN (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/in-transact-sql
- EXISTS (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/exists-transact-sql
- SOME | ANY (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/language-elements/some-any-transact-sql
8 F2F
LO 2 LO 4
SQL –Data Definition (2) - Create and Update View - Dropping Views - Access control : GRANT and REVOKE
command
- SQL – Data Definition (2) - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 7
- Create View (Transact-SQL), http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql
9 F2F
LO 2 Advanced SQL - Cursors - Stored Procedure - Trigger - Function
- Advanced SQL - Database Systems: A
Practical Approach To Design, Implementation, and Management, Chapter 8
- Create Procedure,
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 12
Study Program Information Systems - Bina Nusantara University
http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql
- Create Trigger, http://www.docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql
10 F2F
LO 3 Normalization & Entity Relationship (ER) Modelling
- Normalization Process - UNF, 1NF, 2NF, 3NF - How to use ER Modelling in database design - Basic concepts associated with ER Modelling - A diagrammatic technique for displaying an ER
Modelling
- Normalization & Entity Relationship (ER) Modelling
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 12,13,&14
- Normalization in DBMS, http://www.beginnersbook..com/2015/05/normalization-in-dbms/
- Database Normalization, http://www.scribd.com/doc/2321336/Database-Normalization
- Entity Relationship (ER) Modelling, http://www.inf.unibz.it/~franconi/teaching/2000/ct481/er-modelling/
11 F2F
LO 2 LO 3
Review & Project Submission - Review - Project Submission
- Review & Project Submission
- Database Systems: A Practical Approach To Design, Implementation, and Management, Chapter 6,7,8,12,13,&14
- Entity Relationship (ER) Modelling, http://www.wofford-ecs.org/DataAndVisualization/ermodel/material.htm
8. Evaluation
Theory
Assessment Activity Weight Learning Outcomes
1 2 3 4
Assignment 30% √ √ √ √
Mid Exam 35% √ √ √
Final Exam 35% √ √ √ √
Practicum
Assessment Activity Weight Learning Outcomes
1 2 3 4
Assigment 30% √ √ √ √
Project 30% √ √ √ √
Final Exam 40% √ √ √ √
Course Outline
FM - BINUS - AA - FPA - 27/R0
ISYS6169-Database Systems (CYSEC) | 13
Study Program Information Systems - Bina Nusantara University
Final Evaluation Score
Aspects Weight
Theory 70%
Practicum 30%
9. A. Assessment Rubric (Study Program Specific Outcomes)
LO Indicators
Proficiency Level
Excellent (85 – 100)
Good (75 – 84)
Average (65 – 74)
Poor (<= 64)
LO 1
1.1. Ability to define aspects and components of database systems
The definition is complete and clear stated
The definition is not complete but clear stated
The definition is complete but not clear stated
The definition is not complete and not clear stated
1.2. Ability to identify terminology, environment, and new concept of database
The things needed are complete and clear identified
The needs identified are not complete but clear stated
The needs identified are complete but not clear stated
The needs identified are not complete and not clear stated
1.3. Ability to explain concept of database systems
The description is complete and clear stated
The explanation is not complete but clear stated
The explanation is complete but not clear stated
The explanation is not complete and not clear stated
LO 2
2.1. Ability to demonstrate database language and SQL Programming Language
The language is complete and clear stated
The language is not complete but clear stated
The language is complete but not clear stated
The language is not complete and not clear stated
2.2. Ability to use data manipulation statements of the SQL standard
The syntax needed are complete and clear identified
The syntax identified are not complete but clear identified
The syntax identified are complete but not clear identified
The syntax identified are not complete and not clear identified
2.3. Ability to illustrate SQL Programming Language
The structure of SQL is complete and clear identified
The structure of SQL is not complete but clear identified
The structure of SQL is complete but not clear identified
The structure of SQL is not complete and not clear identified
LO 3
3.1. Ability to explain Database Systems Development Lifecycle and Database Analysis in Database Design
The explanation is complete and clear stated
The explanation is not complete but clear stated
The explanation is complete but not clear stated
The explanation is not complete and not clear stated
3.2. Ability to perform step by step Normalization Process in Database Design
The steps needed are completely identified
The steps identified miss max 2 main points
The steps identified miss a few main points
The steps identified miss most of the main points