MIS Chapter One

The most popular database in the marketplace is called

relational database

What are the 4 types of relationships in the relational database?

1:1, 1:N, N:1, N:M

1:1

one employee belongs to one department

1:N

one employee can be assigned to more than one department

N:1

many of us can belong to the same department

N:M (situation)

many employees can belong to many departments

Moore’s Law (prof)

every two years computers will get faster and the price of it will go down

Moore’s Law (sophi)

states that the number of transistors on a microchip doubles approximately every two years, leading to increases in performance and reductions in relative cost

What in in is the five component framework?

Hardware, software, data, procedures and people

What is the five component framework?

a model that illustrates the essential components for effective information systems

Out of the five componenets; which is really hard to replace if it is lost?

data

What is Data Definition Language (DDL)?

a syntax used to define and manage database structures

Data Manipulation Language (DML)

a syntax used for managing and manipulating data within a database

Which is the first step?

DML

Which is the second step?

DDL

Which SQL keyword are you going to use?

insert into..values to add new data records into a table.

Show me all records from tbldepartment

Select * FROM tbldepartment WHERE dept_id=’aaa’;

If I deleted all the records from the tale department, is the table department gone?

No, because delete is a DML keyword, the only way to destory or remove a table is the keyword from DDT called droptable.

Give me a SQL keyword to delete a record

delete from…. where…

Delete one record from table department where dept_id = aaa?

delete from tbledepartment where dept_id = 'aaa';

Why is Introduction to MIS the most important class in the business school?

it is crucial for its addition to job opportunities

What is MIS?

MIS is about management, use and alignment of IS to achieve business strategies.

An information system is a group of five components that interact to produce information.

How can you use the five component model?

Why is the difference between information technology and information systems important?

IT = hardware + software + data

IS = IT + People + Procedures

What is information?

data presented in a meaningful context

What are necessary data characterstics?

accurate, timely, relevant, just sufficient, worth its cost

2023

everyday items now have embedded computers to collect data and interact over the internet