Study Finals

Question 1

What is meant by Strategic Database Planning

Answer 1

This is about figuring out how to use databases effectively to support the goals of an organization.

Question 1

What is the purpose of Strategic Database Planning?

Answer 1

It ensures that databases are built with the organization’s current and future requirements in mind. This helps avoid wasted resources and ensures scalability.

Question 1

Give an analogy for Strategic Database Planning

Answer 1

Its like laying out the blueprint for building a city, you want to make sure that blueprint meets the city’s current needs but you need to make sure that as the city grows it still performs.

Question 2

Proper planning ensures…

Answer 2

database’s support decision making and improved efficiency.

Question 3

why is strategic planning necessary in the corporate world?

Answer 3

It allows business’s to treat data like a valuable resource. proper database planning allows data integrity which can be used for critical decision making, operations, advertising, promotions etc. Its allows businesses to use their resources correctly and cuts down on cost and waste

Question 4

There are six steps of the DDLC, list them…

Answer 4

Requirement Analysis
Conceptual Design
Logical Design
Physical Design
Implementation
Testing and Maintenance

Question 5

What happens at the Requirement analysis stage

Answer 5

This is where, you’d figure out the needs of why you’d need to build a database. e.g., a school needing to keep tabs on students.

Question 6

what happens in the conceptual design stage?

Answer 6

This is where you create high level models like diagrams to think on what the databse would look like. eg drawing your erd

Question 7

what does the logical design stage look like

Answer 7

so this is where you translate that high level design(diagram) into a more specialized version of itself ie relation.

Question 8

what does the physical design stage look like

Answer 8

Decide how the database will be implemented on hardware

Question 9

The implementation stage consist of

Answer 9

building the database on software, like sql

Question 10

testing and maintenance

Answer 10

where you test for errors and optimize performance.

Question 11

What are some roles of a database administrator

Answer 11

A database administrator:
helps create logical and physical designs
Ensures the database runs smoothly
They control user data access.
they ensure data is recoverable
oversees the database health and smooth operation.

Question 12

Three-Level Database Architecture allows….

Answer 12

data independence which is when data to change at one level without disrupting other levels

Question 13

It has the classifications, list them

Answer 13

Internal
External
Conceptual

Question 14

External Level describes

Answer 14

What the user sees, eg, a student would be able to view their grades without seeing the backend of the database. user only gets the data they need or are allowed to see

Question 15

Conceptual Level describes

Answer 15

This is the overarching design of the database that shows entities and how they relate to each other. Provides a unified view of the data for developers and administrators

Question 16

Internal Level describes

Answer 16

This level deals with the actual storage of data on the disk, including file structures, indexing, and access paths. eg. An index that speeds up searches for customer IDs

Question 17

Give 2 reasons why ANSI/SPARC is important

Answer 17

It only users to see only what they need to see which helps with data security.
You can change one level and it doesn’t affect the other levels because each level operated independently.

Question 18

What are six drawbacks to implementing a database:

Answer 18

Data Breaches:
System Downtime:
Complexity in Maintenance:
High Initial Setup Costs:
Training Costs:
Migration Costs:

Question 19

What is a schema?

Answer 19

a schema is essentially a blueprint for managing and organizing data in a database.

Question 20

What are the differnt types of Data

Answer 20

Structured Data
Semi-Structured Data
Unstructured Data