No student devices needed. Know more
18 questions
Which of the following 2 options should be included in a conceptual data model?
Table names
Entity names
Entity Relationships
Attributes
The logical model is developed from a practical database implementation perspective. It acts as a blueprint for the actual relational database.
True
False
Which of the following options would NOT be included in a physical data model?
Entity names
Column Names
Primary Keys
Column Data Types
What is the following data model an example of?
Conceptual Data Model
Logical Data Model
Physical Data Model
Complete Data Model
In relational algebra, what does this symbol ≤ mean?
Greater than
Less than
Greater than or equal too
Less than or equal too
What will the following relational algebra statement do?
σrelease_year>1997 AND genre=’sci-fi'(Movies)
Select tuples from the movies table where the release year was greater than 1997 and the genre is sci-fi.
Join tuples from the movies table where the release year was greater than 1997 and the genre is sci-fi.
Select tuples from the release year table where the genre is sci-fi.
Join tuples from the release year table where the genre is sci-fi.
What will the following relational algebra statement do?
EMPLOYEE ⋈Employee.deptID = Department.ID DEPARTMENT
Selects Employee and Department tables where the deptID field in the employee table is equal to the ID field in the department table.
Intersects Employee and Department tables where the deptID field in the employee table is equal to the ID field in the department table.
Unions Employee and Department tables where the deptID field in the employee table is equal to the ID field in the department table.
Joins Employee and Department tables where the deptID field in the employee table is equal to the ID field in the department table.
Microsoft Access and MySQL are two popular relational database management systems.
Which of the following factors would lead you to choose Microsoft Access over MySQL?
Usability
Scalability
Cost
Security
Complete the sentence below.
Microsoft Access is not known for being highly compatible as it only works on the ________ operating system.
Linux
Office
Windows
Mac OS
What term do we commonly use to refer to the user interface of a database application?
Back-End
Front-End
Rear-End
User-End
All database software have built-in tools to assist in the creation of forms and reports to help build the user interface.
True
False
Complete the sentence below.
A prototype is a simple version of the final product that only contains the core _________
understanding
functionality
data
relations
Prototyping is best used when we already have a detailed understanding of what the end-users actually want from the database.
True
False
During data conversion, we usually go through a process called data cleaning. What is this?
Where we split up our data and reorganise it in the correct structure for our new system.
Where we identify redundant, incorrect, and invalid data and remove or correct them.
Where we ensure a database is organised in the best way possible.
Where we delete data that is very old from the database.
Data cleaning is where we identify redundant, incorrect and invalid data and remove or correct these to ensure that the integrity of our database isn’t harmed.
True
False
Which of the following 2 are areas we look at to ensure the quality, effectiveness & appropriateness of our database design?
Cleaning of Data
Correctness of Data
Relationships Between Data
Data Conversion
To ensure the database system is a good solution you must ensure your data meets entity and referential integrity requirements.
True
False
Complete the sentence below.
A database that is a quality, effective & appropriate solution must be normalised to _____ normal form.
1st
2nd
3rd
4th
Explore all questions with a free account