Database Management Systems

SQL (Structured Query Language) was developed by Donald D. Chamberlin and Raymond F. Boyce at IBM in the early 1970s. It was originally called SEQUEL. Microsoft developed SQL Server (a database system), Sun was known for Java and MySQL acquisition, and Cisco focuses on networking equipment.

Ingress, PostgreSQL, and MySQL are all open source databases. Ingress was one of the earliest open source databases, while PostgreSQL and MySQL remain among the most widely used open source databases today.

A White List in card-based systems contains the database of all authorized card numbers that are permitted to process transactions. This is a security measure to ensure only valid, approved cards can be used. Red List and other color-coded lists refer to different security concepts in payment systems.

B+ Trees are preferred over B-Trees for filesystems because all data is stored in leaf nodes, making range queries and sequential access much faster. The leaf nodes are linked together, allowing efficient traversal of all records.

In Access, a lookup field can retrieve its values from a Table (pulling data from existing records) or from a Query (dynamically generated data). It cannot look up values from a Report (which is for output) or the Internet (not a native Access feature).

A field's data type determines both the quantity of characters (like Field Size for Text) and the type of characters allowed (numeric vs text, date format validation, etc.). Field format and font style are display properties, not data type characteristics.

A key feature of relational databases and SQL is the independence of table relationships through foreign keys and joins, allowing data to be distributed across multiple tables while maintaining logical connections. SQL execution speed varies, there is no standard GUI, and installation complexity depends on the specific DBMS.

DBMS stands for Database Management System, which is software that manages databases, allowing users to create, retrieve, update, and delete data in an organized and efficient manner. This is the standard industry term.

In relational database terminology, a tuple refers to a single row or record in a table. It contains values for each attribute (column) defined in the table schema. This is the formal mathematical term from relational theory.

TCS works with Scotia Bank across multiple technology areas. The correct combination includes Java (widely used in enterprise applications), .NET (Microsoft ecosystem), and Data Warehousing (for analytics and reporting). Testing is a practice, not a technology area per se.

Lotus Notes (now IBM Notes) is IBM's popular collaborative software platform used for email, calendaring, and messaging in enterprise environments. It has been widely used in corporate settings for decades as a groupware solution.

mysql_connect() was the historical PHP function for connecting to MySQL databases (though deprecated in PHP 5.5 and removed in PHP 7.0). Modern PHP applications should use mysqli_connect() or PDO instead. The other options (mysql_open, dbopen, connect_mysql) are not standard PHP functions. The correct syntax would typically include username, password, and database name parameters.

SQL (Structured Query Language) is a comprehensive database language that supports creating database structures, modifying existing data and schemas, and querying data to retrieve specific information. DDL commands handle creation, DML handles modification, and DQL handles querying.

In database terminology, a field represents a single attribute or category of data, similar to a column in a spreadsheet. Each field contains the same type of information across all records - for example, a 'Phone Number' field would only contain telephone number data, while a record is a complete set of all fields for one entry.