INDR 481 • Midterm • Information Systems

Introduction

Information Systems in Organizations

Soft Side of Implementing Change

Careers in Information Systems

Hardware

Servers

Software

Operating Systems

Introduction to Database

Data Modelling

Manipulating Data

Big Data

What is Database Design?

Requirements Analysis

Conceptual Design

Logical Design

Physical Design

Introduction to ER Diagrams

Entities

Attributes

Relationship Types

Cardinality

ER diagrams with Table

Example-1

Example-2

Example-3

Examlike-1

Examlike-2

SELECT

Arithmetic Expressions

Column Aliases

Where Clause

Comparison Operators

Logical Operators

ORDER BY

Introduction to Joins

INNER JOIN

LEFT-RIGHT JOIN

CROSS-SELF JOIN

Introduction

Case-Conversion Functions

Character Manipulation Functions -1

Character Manipulation Functions -2

Number Functions

Date Functions

Conversion Functions

IF()

CASE

Group Functions

GROUP BY

HAVING

Subqueries

Multiple-Row Subqueries

Multiple-Column Subqueries

INSERT

UPDATE - DELETE

Database Transactions

CREATE TABLE

Constraints

ALTER TABLE

Keys

Normalizations

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10