Databases

From Computer Science Wiki
Jump to: navigation, search
Databases[1]
A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.[2]

Big Ideas in Databases

  • Data modeling
  • Entity relationship diagramming
  • Entity relationships
  • Working with entity relationships
  • Normalization
  • Unique identifiers
  • Transforming From Conceptual Model to Physical Model
  • Introduction to SQL
  • SELECT Statements and Relational Database Technology
  • Using the WHERE Clause
  • Restricting Rows and Introduction to Functions
  • Using Character, NumberA unit of abstract mathematical system subject to the laws of arithmetic., and Date Functions
  • Using Single Row Functions
  • Fundamentals of Database Security
  • Understanding Database Transactions
  • MySQL: monitoring and performance
  • MySQL: security
  • ACID
  • CRUD
  • NoSQL (Advanced)


Standards

These standards are taken from the IB Computer Science database option. [3]


  • DiscussOffer a considered and balanced review that includes a range of arguments, factors or hypotheses. Opinions or conclusions should be presented clearly and supported by appropriate evidence. the need for databases.
  • OutlineGive a brief account. the differences between data and information.
  • OutlineGive a brief account. the differences between an information system and a database.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. the use of transactions, states and updates to maintain data consistency (and integrity).
  • DefineGive the precise meaning of a word, phrase, concept or physical quantity. the term database transaction.
  • ExplainGive a detailed account including reasons or causes. concurrency in a data sharing situation.
  • ExplainGive a detailed account including reasons or causes. the importance of the ACID properties of a database transaction.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. the two functions databases require to be performed on them.
  • ExplainGive a detailed account including reasons or causes. the role of data validation and data verification.
  • ExplainGive a detailed account including reasons or causes. data modeling
  • ApplyUse an idea, equation, principle, theory or law in relation to a given problem or issue. understanding of entity relationship diagramming
  • DefineGive the precise meaning of a word, phrase, concept or physical quantity. entity relationships
  • UseApply knowledge or rules to put theory into practice. unique identifiers and normalizationNormalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.
  • DefineGive the precise meaning of a word, phrase, concept or physical quantity. the terms: database management system (DBMS) and relational database management system (RDBMS).
  • OutlineGive a brief account. the functions and tools of a DBMS.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. how a DBMS can be used to promote data security.
  • DefineGive the precise meaning of a word, phrase, concept or physical quantity. the term schema.
  • IdentifyProvide an answer from a number of possibilities. Recognize and state briefly a distinguishing fact or feature. the characteristics of the three levels of the schema: conceptual, logical, physical.
  • OutlineGive a brief account. the nature of the data dictionary.
  • ExplainGive a detailed account including reasons or causes. the importance of a data definition language in implementing a data model.
  • ExplainGive a detailed account including reasons or causes. the importance of data modelling in the designProduce a plan, simulation or model. of a database.
  • DefineGive the precise meaning of a word, phrase, concept or physical quantity. the following database terms: table, record, field, primary key, secondary key, foreign key, candidate key, composite primary key, join.
  • IdentifyProvide an answer from a number of possibilities. Recognize and state briefly a distinguishing fact or feature. the different types of relationships within databases: one-to- one, one-to-many, many-to-many.
  • OutlineGive a brief account. the issues caused by redundant data.
  • OutlineGive a brief account. the importance of referential integrity in a normalized database.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. the differences between 1st Normal Form (1NF), 2nd Normal Form (2NF) and 3rd Normal Form (3NF).
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. the characteristics of a normalized database.
  • EvaluateAssess the implications and limitations; make judgments about the ideas, works, solutions or methods in relation to selected criteria. the appropriateness of the different data types.
  • ConstructDevelop information in a diagrammatic or logical form. an entity-relationship diagram (ERD) for a given scenario.
  • ConstructDevelop information in a diagrammatic or logical form. a relational database to 3NF using objects such as tables, queries, forms, reports and macros.
  • ExplainGive a detailed account including reasons or causes. how a query can provide a view of a database.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. the difference between a simple and complex query.
  • OutlineGive a brief account. the different methods that can be used to constructDevelop information in a diagrammatic or logical form. a query.
  • ExplainGive a detailed account including reasons or causes. the role of a database administrator.
  • ExplainGive a detailed account including reasons or causes. how end-users can interact with a database.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. different methods of database recovery.
  • OutlineGive a brief account. how integrated database systems function.
  • OutlineGive a brief account. the use of databases in areas such as stock control, police records, health records, employee data.
  • SuggestPropose a solution, hypothesis or other possible answer. methods to ensure the privacy of the personal data and the responsibility of those holding personal data not to sell or divulge it in any way.
  • DiscussOffer a considered and balanced review that includes a range of arguments, factors or hypotheses. Opinions or conclusions should be presented clearly and supported by appropriate evidence. the need for some databases to be open to interrogation by other parties (police, government, etc).
  • ExplainGive a detailed account including reasons or causes. the difference between data matching and data mining.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. the characteristics of different database models.
  • EvaluateAssess the implications and limitations; make judgments about the ideas, works, solutions or methods in relation to selected criteria. the use of object-oriented databases as opposed to relational databases.
  • DefineGive the precise meaning of a word, phrase, concept or physical quantity. the term data warehouse.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. a range of situations suitable for data warehousing.
  • ExplainGive a detailed account including reasons or causes. why data warehousing is time dependent.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. how data in a warehouse is updated in real time.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. the advantages of using data warehousing.
  • ExplainGive a detailed account including reasons or causes. the need for ETL processes in data warehousing.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. how ETL processes can be used to clean up data for a data warehouse.
  • Compare the different forms of discovering patterns using data mining.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. situations that benefit from data mining.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. how predictive modelling is used.
  • ExplainGive a detailed account including reasons or causes. the nature of database segmentation.
  • ExplainGive a detailed account including reasons or causes. the nature and purpose of link analysis.
  • DescribeGive a detailed account or picture of a situation, event, pattern or process. the process of deviation detection.

See also

  1. Please take a look at our SQL page

References

  1. http://www.flaticon.com/
  2. https://en.wikipedia.org/wiki/Database
  3. IB Diploma Program Computer science guide (first examinations 2014). Cardiff, Wales, United Kingdom: International Baccalaureate Organization. January 2012.