Data Modelling — Learn free

Self-check

Questions 1–10 of 10

1. What is Data Modelling?
Question 1A. The practice of backing up databases on a scheduleB. The practice of structuring, describing and organising information so it reflects real-world entities, relationships, rules and contextsC. The practice of writing SQL queries for reportsD. The practice of tuning database indexes for speedE. The practice of migrating data between cloud providers
2. Approximately how many Data Modelling techniques exist, according to *I Am Datapedia!*?
Question 2A. Around 37B. Around 5C. Around 12D. Around 100E. Exactly 3
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?
Question 3A. A Normalised data modelB. A Dimensional data modelC. A NoSQL graph modelD. A Time-Based modelE. A Denormalised data model
4. In the monthly salary example, which option represents data modelling in the Normalisation way?
Question 4A. Replacing the first month's salary with the second month's salaryB. Adding a new column such as salary_2ndmonth every monthC. Deleting the salary column altogetherD. Breaking employee details into separate Employee and Salary tables, carrying the employee ID into the Salary tableE. Storing salaries in a text file outside the database
5. Why is adding a new salary column for every month not a viable option?
Question 5A. Because databases forbid more than one salary columnB. Because you would have to add a new column every monthC. Because salaries cannot be stored as numbersD. Because it would delete the employee IDE. Because it would violate a dimensional schema
6. What is a Unary Relationship?
Question 6A. Two tables joined with each otherB. Three tables joined through an intermediate tableC. A column that depends on another column within the same table, giving an internal joinD. A fact table joined to a dimension tableE. A relationship between two databases
7. Which relationship type involves three tables joined with the help of an intermediate table?
Question 7A. UnaryB. BinaryC. TernaryD. RelationalE. Dimensional
8. Which data modelling scheme uses a fact table joined with dimension tables, as in Star and Snowflake schemas?
Question 8A. DimensionalB. RelationalC. Object-Oriented (UML)D. Fact-BasedE. NoSQL
9. Which scheme is described as a graphical language for modelling software itself, consisting of a Class Model with entity types and relationship types?
Question 9A. RelationalB. Time-BasedC. NoSQLD. Object-Oriented (UML)E. Dimensional
10. Which of the following is NOT one of the NoSQL database kinds named in the Data Modelling schemes?
Question 10A. GraphB. DocumentC. Key-valueD. Column-orientedE. Star schema