ITEC 205

What does RDBMS stand for?

What does RDBMS stand for?

Relational Database Management System.

What is the basis for SQL?

Relational Database Management System (RDBMS).

Which database systems are based on RDBMS?

MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

What is a table in RDBMS?

A collection of related data entries organized in columns and rows.

What does a field represent in a table?

A column designed to maintain specific information about each record.

What is a record in a table?

An individual entry or row in a database table.

What is the role of a column in a table?

A vertical entity that contains all information associated with a specific field.

What is a NULL value?

A field without a value, distinctly different from zero or empty spaces.

What are SQL Constraints?

Rules enforced on data columns to ensure accuracy and reliability.

What is a NOT NULL constraint?

A constraint that ensures a column cannot have a NULL value.

What does a UNIQUE constraint do?

Ensures all values in a column are different.

What is the purpose of a PRIMARY Key?

Uniquely identifies each row/record in a table.

What is a FOREIGN Key?

A key that uniquely identifies a row in another database table.

What is the CHECK constraint?

Ensures all values in a column satisfy certain conditions.

What is INDEX used for?

To create and retrieve data quickly from the database.

What is Entity Integrity?

Ensures no duplicate rows exist in a table.

What is Domain Integrity?

Enforces valid entries for a given column by restricting type, format, or range of values.

What is Referential Integrity?

Prevents deletion of rows that are in use by other records.

What is User-Defined Integrity?

Enforces specific business rules that do not fall into other categories of integrity.

What is normalization in databases?

A design technique to reduce data redundancy and eliminate anomalies.

What are the types of Normal Forms?

1NF, 2NF, 3NF, BCNF.

What are the rules of 1NF?

Each table cell should contain a single value and each record needs to be unique.

What is a KEY in a database context?

A value used to identify a record uniquely.

What defines a Primary Key?

A unique identifier for a record that cannot be NULL.

What is a Composite Key?

A primary key made up of multiple columns to identify a record uniquely.

What are the rules for 2NF?

Must be in 1NF and have a single-column primary key.

What is a transitive functional dependency?

When changing a non-key column can affect other non-key columns.

What are Operational decisions?

Day-to-day decisions affecting the organization's running.

What are Tactical decisions?

Decisions made by middle management with a longer time frame.

What defines Strategic decisions?

Decisions made by top management affecting long-term company plans.

What is a Management Information System (MIS)?

A computer system providing reports and data analysis for management decisions.

What is the primary purpose of a MIS?

To support management by providing necessary information.

What are examples of data processed by an MIS?

Financial reports, operational stats, and performance metrics.

What distinguishes a Decision Support System (DSS)?

Analyzes data to assist with decision-making often used for tactical and strategic levels.

What does an Executive Support System (ESS) do?

Helps executives analyze data and make informed strategic decisions.

What are the components of a Database Management System (DBMS)?

People, processes, data, hardware, and software.

What is the main focus of a Hierarchical DBMS?

Data organized in a tree-like structure with parent-child relationships.

What is a Network Model in DBMS?

Allows each child to have multiple parents, creating complex relationships.

What sets apart the Relational model?

Stores data in tables normalized by rows and columns, manipulated using SQL.

What is the Object-Oriented Model in DBMS?

Data is stored in objects, defined by classes.

What is the significance of data in a DBMS?

Data represents the real world aspects collected for particular tasks.

What defines a flat file database?

A simple database without complex relationships, suitable for small data sets.

What is a Backlink in SEO?

A link from one website to another, contributing to SEO strength.

What does On-Page SEO involve?

Optimization of title tags, meta descriptions, and content quality.

What is involved in Off-Page SEO?

Building backlinks, managing online reputation, and social media presence.

What are key components of Technical SEO?

Site speed, mobile optimization, and secure connections.

What is the objective of Keyword Research?

To identify relevant keywords that improve website visibility on search engines.

What are the advantages of using an MIS?

Facilitates planning, minimizes information overload, and brings coordination.

What are potential disadvantages of MIS?

High cost, lack of flexibility, and risk of fraud.

What is the primary benefit of Executive Information Systems?

Providing summarized information for strategic decision-making.

What is a Transaction Processing System?

Captures daily transactional data for ongoing operations.

What is a School Information Management System (SIMS)?

A system that helps manage a school's operations and student records.