Info Sytems Midterm Notes.docx - Types of Questions 1 Q1 Definition\/Terms 2 Q2 sum(2:3 3 Q3 Screenshot 1 What is info system a 4 components 2 What is

Info Sytems Midterm Notes.docx - Types of Questions 1 Q1...

This preview shows page 1 out of 1 page.

Types of Questions: 1) Q1: Definition/Terms 2) Q2: sum(2:3) 3) Q3: Screenshot 1) What is info system? a) 4 components 2) What is database? a) -What is the benefit and what does it minimize and maximize? 3) Attribute(field) relationship, entity, record(instance), table 4) Primary key, compositional primary key, foreign key a) Unique field b) Unique combination of fields 5) What is form? (def, why we use form) 6) What is query? (def, why we use it?)\ a) 4 types of queries: i) Update ii) Select iii) Total iv) Parameter 7) Report 8) Cardinality, Modality (def, ERD) a) ERD graph b) Know symbols and how to read the relationships 9) SQL a) SELECT____FROM_____ WHERE _____ 10) Excel-Week 3 a) Related with Decision support system
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

  • Spring '13
  • Unknown

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture