Database Terminology - Revision history

Bacchas at 21:09, 20 September 2017

2017-09-20T21:09:32Z

← Older revision		Revision as of 21:09, 20 September 2017
Line 1:		Line 1:
	==Database Basics==		==Database Basics==
	=== Conceptual Model ===		=== Conceptual Model ===
			''' Is called an Entity Relationship Model'''
	* Captures the functional and informational needs of a business		* Captures the functional and informational needs of a business
	* Is based on current needs but may reflect future needs		* 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)		* 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===		===RDBMS - Relational Database Management System===
	===Schema - Set of db objects representing part or all of a business enterprise		===Schema - Set of db objects representing part or all of a business enterprise

Bacchas at 21:04, 20 September 2017

2017-09-20T21:04:21Z

← Older revision		Revision as of 21:04, 20 September 2017
Line 1:		Line 1:
	==Database Basics==		==Database Basics==
			=== Conceptual 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)
	===RDBMS - Relational Database Management System===		===RDBMS - Relational Database Management System===
	===Schema - Set of db objects representing part or all of a business enterprise		===Schema - Set of db objects representing part or all of a business enterprise

Bacchas at 22:51, 11 September 2017

2017-09-11T22:51:26Z

← Older revision		Revision as of 22:51, 11 September 2017
Line 1:		Line 1:
	==Database Basics==		==Database Basics==
			===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)

Bacchas at 14:52, 11 September 2017

2017-09-11T14:52:53Z

← Older revision		Revision as of 14:52, 11 September 2017
Line 1:		Line 1:
			==Database Basics==
	* 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 10:		Line 11:
	----		----

	[[#Database ~~Terminology~~\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Database Basics\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 14:50, 11 September 2017

2017-09-11T14:50:16Z

← Older revision		Revision as of 14:50, 11 September 2017
Line 7:		Line 7:
	'''Database Design'''		'''Database Design'''
	System Development Life Cycle (SDLC)		System Development Life Cycle (SDLC)
	-
			----

	[[#Database Terminology\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Database Terminology\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 14:49, 11 September 2017

2017-09-11T14:49:39Z

← Older revision		Revision as of 14:49, 11 September 2017
Line 8:		Line 8:
	System Development Life Cycle (SDLC)		System Development Life Cycle (SDLC)
	-		-
			[[#Database Terminology\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 16:29, 8 September 2017

2017-09-08T16:29:04Z

← Older revision		Revision as of 16:29, 8 September 2017
Line 5:		Line 5:
	* A group of records about the same type of entity (such as customers or inventory items) is stored in a file.		* 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.		* 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)
			-

Bacchas: Created page with "* 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..."

2017-09-08T15:34:19Z

Created page with "* 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..."

New page

* 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.