Business Modeling

Note- The underlined text in the exercises indicates weblinks. Don't miss those.

  1. What is the use of Excel ribbon?

  2. Arrange the following operations in order of precedence in Excel- exponentiation, concatenation, addition, percent, division.

  3. What are reference operators in Excel?

  4. Please answer the questions in the spreadsheet based on the data. You will have to download the excel file to answer.

  5. BONUS FUN STUFF- try playing with this infographic :-). You will enjoy it. Data is so much fun!

Database Management Systems

  1. What is an entity and an attribute? Give examples.

  2. How did DBMS evolve. Explain the different types of DBMS.

  3. What is parent child relationship. Which types of DBMS use this to store data?

  4. What is a network model in the context of a DBMS?

  5. What is the difference between network DBMS and relational DBMS? 

  6. What are relations?

  7. What's the difference between a table and a database?

  8. What is an open source DBMS? Give few examples.

  9. What is a difference between SQL, MySql, Oracle, Sql server?

  10. Which of the following systems must use a DBMS?

    1. Mobile phone

    2. Website

    3. Revenue services department

    4. Conventional calculator

  11. What is meant by objects in databases?