Study Finals Flashcards
finals
What is meant by Strategic Database Planning
This is about figuring out how to use databases effectively to support the goals of an organization.
What is the purpose of Strategic Database Planning?
It ensures that databases are built with the organization’s current and future requirements in mind. This helps avoid wasted resources and ensures scalability.
Give an analogy for Strategic Database Planning
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.
Proper planning ensures…
database’s support decision making and improved efficiency.
why is strategic planning necessary in the corporate world?
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
There are six steps of the DDLC, list them…
Requirement Analysis
Conceptual Design
Logical Design
Physical Design
Implementation
Testing and Maintenance
What happens at the Requirement analysis stage
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.
what happens in the conceptual design stage?
This is where you create high level models like diagrams to think on what the databse would look like. eg drawing your erd
what does the logical design stage look like
so this is where you translate that high level design(diagram) into a more specialized version of itself ie relation.
what does the physical design stage look like
Decide how the database will be implemented on hardware
The implementation stage consist of
building the database on software, like sql
testing and maintenance
where you test for errors and optimize performance.
What are some roles of a database administrator
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.
Three-Level Database Architecture allows….
data independence which is when data to change at one level without disrupting other levels
It has the classifications, list them
Internal
External
Conceptual
External Level describes
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
Conceptual Level describes
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
Internal Level describes
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
Give 2 reasons why ANSI/SPARC is important
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.
What are six drawbacks to implementing a database:
Data Breaches:
System Downtime:
Complexity in Maintenance:
High Initial Setup Costs:
Training Costs:
Migration Costs:
What is a schema?
a schema is essentially a blueprint for managing and organizing data in a database.
What are the differnt types of Data
Structured Data
Semi-Structured Data
Unstructured Data
