Exam (elaborations)
Concepts of DATABASE MANAGEMENT
- Course
- DATABASE MANAGEMENT
- Institution
- Chamberlain College Of Nursing
Concepts of DATABASE MANAGEMENT
[Show more]
Seller
Follow
Content preview
Concepts of DATABASE MANAGEMENT1. Define 1st, 2nd, 3rd, and 4th normal forms:
1st normal form: Data is in a table with unique rows, and all columns contain atomic
values.
2nd normal form: Meets 1st normal form and removes partial dependencies
(dependencies on part of a composite key).
3rd normal form: Meets 2nd normal form and removes transitive dependencies (non-
key attributes depend only on the primary key).
4th normal form: Meets 3rd normal form and ensures no multi-valued dependencies
exist.
2. Atomic value –
An indivisible value, such as a single number, word, or date, used in a database field.
3. Attach an ER(Entity Relationship) diagram and explain it.
, Represents entities, attributes, and their relationships in a database.
5.what is github - A web-based platform for version control and collaboration using Git,
allowing developers to manage and share their code.
Git – A distributed version control system for tracking changes in source code during
software development.
Github – A platform that hosts Git repositories and provides tools for collaboration, such as
issue tracking and pull requests.
6. If you use AND criteria, each criterion must be true for a record to be selected.
7. In an entity relationship model, what does the diamond represent?
Represents relationships between entities.
8. What do Data Scientists typically look for as they analyze data?
They analyze patterns, correlations, trends, and anomalies in data to derive actionable
insights.
9. What career opportunities do databases offer?
Offer career opportunities like database administrator, data analyst, and database
architect, focusing on data management, analysis, and infrastructure design.
10. what is a left join?
Retrieves all records from the left table and matching records from the right table;
unmatched records in the right table are null.
11. what is a right join?
Retrieves all records from the right table and matching records from the left table;
unmatched records in the left table are null.
12.what is an inner join?
Retrieves only the records that have matching values in both tables.
13.what is an outer join?
Combines all records from both tables, showing nulls for non-matching rows.
14. what is oracle?
A database management system that provides robust features for data storage, retrieval,
and management.
15. Using the bureau of labor statistics website.
Cover the competencies required of a database administrator. How much do they get payed?
What languages do they know? Use The bureau of labor statistics.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller StephanieWhitney. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $34.42. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75759 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now