Pt2520 Lab 5.1

A database administration framework (DBMS) is a PC programming application that connects with the client, different applications, and the database itself to catch and dissect information. A universally useful DBMS is intended to permit the definition, creation, questioning, upgrade, and organization of databases.

One to one, one to many and many to many: These three relationship types. One to one is where one piece of data is exchanged with another one. One to many is where piece of data is exchanged with many pieces of data. Many to many is where lots of pieces of data is exchanged with lots of other pieces of data.

A database administrator role in a company is vital to the future success. According to the Bureau of Labor Statistics, database admins use computer programs and special software to organize data, and turn it into information for its users. Of the three positions at Vigo, a database administrator requires the highest level of education, prior job experience and training. The responsibilities include protecting data from breaches, providing ease of access to users, and be able to work with management to create goals based off the data. The median annual income for database administrators is about $85,000. The projected growth is

A row in a table is associated to one and only one row in another table. An example of a one-to-one relationship is a person can have one social security number and a social security number can only be assigned to one person.

Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.

A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity.

Firstly a relational database contains a set of tables which basically are linked collectively by the relationships between the tables. Also it is also known as reason such as a database is called relational database.

The FOREIGN KEY constraint is usually placed on the "one" side of a one-to-many relationship. _________________________

The example discussed above on Customers table and Orders table is a one-to-many relationship. As each customer places multiple orders, each order only belongs to one customer. When creating a relationship between two tables, if only one of the related fields is unique, a one-to-many relationship is automatically set.

Business Rules: In the entity-relationship data models, business rules must take into account all relationship models: one-to-many (1:M), one-to-one (1:1) and many-to-many (M:N). For a database on a school library, a restriction of having a student only allowed to borrow one book would need a 1:1 relationship.

* Describe the role of databases and database management systems in managing organizational data and information.

Example 1 – Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment:

The responsibility of a database administrator is to serve as the link between the database designers, knowledge managers and users. The database designers are often brought in for completing specific projects and then moving onto other projects at other companies or different departments at the same company. Their job are usually finished when they finish designing the database. While they may be used in the future to perform some

To enforce referential integrity for this relationship, select the Enforce Referential Integrity check box. Click Create. Access draws a relationship line between the two tables. If you selected the Enforce Referential Integrity check box, the line appears