Difference between revisions of "Database Terminology"
Jump to navigation
Jump to search
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Database Basics== | |||
=== Conceptual Model === | |||
''' Is called an Entity Relationship Model''' | |||
* Captures the functional and informational needs of a business | |||
* Is based on current needs but may reflect future needs | |||
* addresses the needs of a business(what is conceptually ideal), but does not address its implementation (what is physically possible) | |||
===Data Modeling === | |||
* the process of capturing the importing concepts and rules that shape a business and depicting them visually on a diagram. | |||
===RDBMS - Relational Database Management System=== | |||
===Schema - Set of db objects representing part or all of a business enterprise | |||
* A character is the basic unit of data, and it can be a letter, number or special symbol | * A character is the basic unit of data, and it can be a letter, number or special symbol | ||
** A group of related characters (for example, the characters that make up a customer's name) is called a field) | ** A group of related characters (for example, the characters that make up a customer's name) is called a field) | ||
| Line 7: | Line 18: | ||
'''Database Design''' | '''Database Design''' | ||
System Development Life Cycle (SDLC) | System Development Life Cycle (SDLC) | ||
- | |||
[[#Database | ---- | ||
[[#Database Basics|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | |||
Latest revision as of 21:09, 20 September 2017
Database Basics
Conceptual Model
Is called an Entity Relationship Model
- Captures the functional and informational needs of a business
- Is based on current needs but may reflect future needs
- addresses the needs of a business(what is conceptually ideal), but does not address its implementation (what is physically possible)
Data Modeling
- the process of capturing the importing concepts and rules that shape a business and depicting them visually on a diagram.
RDBMS - Relational Database Management System
===Schema - Set of db objects representing part or all of a business enterprise
- A character is the basic unit of data, and it can be a letter, number or special symbol
- A group of related characters (for example, the characters that make up a customer's name) is called a field)
- A field represents one attribute or characteristic (the name, for instance) of the customer.
- A collection of fields about one customer (for example, name, address, city, state, and zip) is called a record
- A group of records about the same type of entity (such as customers or inventory items) is stored in a file.
- A collection of interrelated files-such as those relating to customers, their purchases, and their payments- is stored in a database.
Database Design System Development Life Cycle (SDLC)