Data Modelling
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is Data Modelling?
2. Approximately how many Data Modelling techniques exist, according to *I Am Datapedia!*?
3. Storing all of an employee's details (ID, name, mobile, address, salary, department) in one row of a spreadsheet illustrates which kind of data model?
4. In the monthly salary example, which option represents data modelling in the Normalisation way?
5. Why is adding a new salary column for every month not a viable option?
6. What is a Unary Relationship?
7. Which relationship type involves three tables joined with the help of an intermediate table?
8. Which data modelling scheme uses a fact table joined with dimension tables, as in Star and Snowflake schemas?
9. Which scheme is described as a graphical language for modelling software itself, consisting of a Class Model with entity types and relationship types?
10. Which of the following is NOT one of the NoSQL database kinds named in the Data Modelling schemes?