Huwebes, Agosto 25, 2011

Definitions

 DEFAULT 

  • Default values are generally intended to make a device (or control) usable "out of the box". A common setting, or at least a usable setting, is typically assigned.
MS RIBBON

  • In GUI-based application software, a ribbon is an interface where a set of toolbars are placed on tabs in a tab bar. Recent releases of some Microsoft applications have embraced this form with a modular ribbon as their main interface. The Ribbon GUI provides the user interface of an application with a large toolbar filled with graphical representations of control elements which are grouped by different functionality. The Ribbon can also contain tabs to expose different sets of control elements eliminating the need for a lot of different icon-based tool bars. Some of these tabs are contextual and appear only when a certain type of object is selected, providing specific tools for items such as tables or images.

    •  Microsoft touted the ribbon as "the modern way to help users find, understand, and use commands efficiently and directly—with a minimum number of clicks, with less need to resort to trial-and-error, and without having to refer to Help.” Microsoft originally implemented ribbons as part of its "Fluent User Interface" in Office 2007.[1] The ribbon is formed as a fixed-size panel that houses certain command buttons and icons; it organizes commands as a set of tabs, each grouping relevant commands. Each application has a different set of tabs which house the options for that specific application. Within each tab, various related options may be grouped together. The Ribbon can be minimized by double clicking the active tab.[2] The ribbon consolidates the functionality previously found in menus, toolbars and many task panes into one area.[3]
    • In Microsoft Office 2007 the Ribbon interface was limited to the main Word, Excel, Access and PowerPoint applications. but was introduced across all Office applications for their 2010 versions.[4]
      The ribbon UI has also begun to be implemented in other Microsoft software like Windows, SQL Server and Dynamics CRM 2011.[5] The Windows 7 applications Paint and WordPad now utilize a ribbon-based UI, [6] as also some of the Windows Live Essentials applications like Windows Live Mail, Windows Photo Gallery, Windows Live Movie Maker and Windows Live Writer [7], as well as in the Windows 8 Explorer. The ribbon UI is also featured in Microsoft Mathematics 4.0 and Microsoft WebMatrix.
      The Office 2007 Ribbon can be customized by adding a "customUI" RibbonX xml file document to an Office Open XML document type. Office 2010 supports end-user customization via the application GUI.
        
      ONE TO MANY RELATIONSHIP
      PRIMARY KEY

      • The primary key of a relational table uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number in a table with no more than one record per person) or it can be generated by the DBMS (such as a globally unique identifier, or GUID, in Microsoft SQL Server). Primary keys may consist of a single attribute or multiple attributes in combination.

      FOREIGN KEY

      • A foreign key is a field in a relational table that matches a candidate key of another table. The foreign key can be used to cross-reference tables.
        The foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. The columns in the referencing table must reference the columns of the primary key or other superkey in the referenced table. The values in one row of the referencing columns must occur in a single row in the referenced table. Thus, a row in the referencing table cannot contain values that don't exist in the referenced table (except potentially NULL). This way references can be made to link information together and it is an essential part of database normalization. Multiple rows in the referencing table may refer to the same row in the referenced table. Most of the time, it reflects the one (parent table or referenced table) to many (child table, or referencing table) relationship.
        The referencing and referenced table may be the same table, i.e. the foreign key refers back to the same table. Such a foreign key is known in SQL:2003 as a self-referencing or recursive foreign key.
        A table may have multiple foreign keys, and each foreign key can have a different r eferenced table. Each foreign key is enforced independently by the database system. Therefore, cascading relationships between tables can be established using foreign keys.
        Improper foreign key/primary key relationships or not enforcing those relationships are often the source of many database and data modeling problems.

Sabado, Hulyo 2, 2011

What is Database management System(DBMS)?

       
                        A Database Management System (DBMS) is a software package with computer programs that control the creation, maintenance, and the use of a database. It allows organizations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists.
 A Database management System is a collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMS's, ranging from small systems that run on personal computers to huge systems that run on mainframes.
http://www.webopedia.com/TERM/D/database_management_system_DBMS.html
 
A database management system (DBMS), sometimes just called a database manager, is a program that lets one or more computer users create and access data in a database. The DBMS manages user requests (and requests from other programs) so that users and other programs are free from having to understand where the data is physically located on storage media and, in a multi-user system, who else may also be accessing the data. In handling user requests, the DBMS ensures the integrity of the data (that is, making sure it continues to be accessible and is consistently organized as intended) and security (making sure only those with access privileges can access the data). The most typical DBMS is a relational database management system (RDBMS
http://searchsqlserver.techtarget.com/definition/database-management-system
 
Database Management Systems has quickly become one of the leading texts for database courses, known for its practical emphasis and comprehensive coverage. The third edition features new material on database application development, with a focus on Internet applications. The hands-on approach introduces students to current standards, including JDBC, XML, and 3-tier application architectures. A new, flexible organization allows instructors to teach either an applications-oriented course or an introductory systems-oriented course.  The revised “part” organization with (new) Overview chapters makes it easy to select the chapters you need; in-depth chapters within each part can be optional.
http://pages.cs.wisc.edu/~dbbook/
 
A Database Management System (DBMS) is a collection of software programs which enable large, structured sets of data to be stored, modified, extracted and manipulated in different ways.
http://www.bestpricecomputers.co.uk/glossary/database-management-systems.html
 
 
  What is DBMS for me?
Well, Database management system(DBMS) is a database program that uses a standard method that manages how to organize and provides something ways  on the incoming data to be modified by the users or on the other program . It helps in terms of the process thing to be more efficient and effortless . 
Database management system also provides easier life according to our new generation now. It manages data  on how to catalog, retrieve and run queries or questions about the data and of course store it for others to make use of it.

"jevzdluxe"





 

Sabado, Hunyo 25, 2011

Object Oriented model Vs. Flat file model



The difference between Object oriented and Flat file model

The object oriented structure has the ability to handle graphics, pictures, voice and text, types of data, without difficultly unlike the other database structures. This structure is popular for multimedia Web-based applications. It was designed to work with object-oriented programming languages such as Java.


Vs.


A flat file database describes any of various means to encode a database model (most commonly a table) as a single file (such as .txt or .ini).

Multidimensional model vs. Flatfile model



The difference between multidimensional and Flat file model


The multidimensional structure is similar to the relational model. The dimensions of the cube-like model have data relating to elements in each cell. This structure gives a spreadsheet-like view of data. This structure is easy to maintain because records are stored as fundamental attributes - in the same way they are viewed - and the structure is easy to understand. Its high performance has made it the most popular database structure when it comes to enabling online analytical processing (OLAP).

Vs.


A flat file database describes any of various means to encode a database model (most commonly a table) as a single file (such as .txt or .ini).


Relational model Vs. Flat file model


The difference between Relational and Flat file model

The relational model for database management is a database model based on first-order predicate logic, first formulated and proposed in 1969 by E.F. Codd.
Vs.
A flat file database describes any of various means to encode a database model (most commonly a table) as a single file (such as .txt or .ini).



Network model Vs. Flat file db model


The Difference between Network and Flat file model


  The network model is a database model conceived as a flexible way of representing objects and their relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice.







Vs.
A flat file database describes any of various means to encode a database model (most commonly a table) as a single file (such as .txt or .ini).

Hierarchical model vs. Flatfile db model



 The Difference between Hierarchical and Flat file model


A hierarchical data model is a data model in which the data is organized into a tree-like structure. The structure allows representing information using parent/child relationships: each parent can have many children but each child only has one parent (also known as a 1:many ratio ). All attributes of a specific record are listed under an entity type.



Vs.

 



A flat file database describes any of various means to encode a database model (most commonly a table) as a single file (such as .txt or .ini).