Curtis Fowlkes CIS111 July 14, 2016 Assignment 1: Business Rules and Data Models

The purpose of a database is to collect, store and organize data. A database can be abruptly described as a repository for data. This explains that building databases is really an extension of a human activity that has lasted since writing began and it can be applied to the result of any bookkeeping or recording activity that happened long before the arrival of the computer era. The creation of a database is required by the operation of an enterprise.

The college keeps records of its students, its instructors, the courses that are taught by the college, the grades the students receive, and the assignments of advisors to students, as well as other aspects of the activity of the institution.
Most online databases are measured relational databases and are shaped using controlled query language generally referred to as SQL. This type of database uses multiple tables of data that are related and ties them together with keys; a common identifying code. In database language, the white pages contain a table in which each subscriber is represented by a record and each subscriber record includes three fields: name, address, and phone number. The records are arranged alphabetically by the name field, which is called the key field. Entities are the things in the real world that we will store information about in the database.
A student would be one entity and the class would be another. Relationships are the links between those two entities. For example, a student attends a class. Attend– is the relationship between the student and the class.
Relationship comes in different amounts. They can be one to one, one too many, many to one or many too many. A one to one relationship connects precisely to entities. If a student at the university had a desk each, it would be a one to one relationship. The class for relationship is minty to one relationship.
In database tables, each column replaces some piece of data that each record in the
Table has. The term column is used rather alternately, but a column is really part of a table.
Keys are very vital concepts in database design. Keys come in five basic marks; Super Keys, Candidate Keys, Primary Keys, Foreign Keys, and Keys. A Super Key is a column or set of columns that can be used to identify a row in a table. A Key is the smallest Super Key.
Users, the community of users of a DBMS includes a variety of individuals and
Organizational entities. These users are divided upon their roles and interests in accessing and managing the databases. Once a database has been created, it’s the job of the database admin to make decisions about the the nature of data to be stored, the access policy/policies to be enforced, monitoring and turning the performance of the database. Systems analysts have long been able to describe an enterprise in terms of the structure of the data that enterprise uses and the organization of the functions it performs, but they have tended to desert the bounds under which the enterprise operates. The techniques of systems analysis have advanced over the years to provide approaches for describing many positions of a business or government agency. We can now draw pictures of the way information flows through an organization, the sequence of actions an organization will follow, the structure of its operating information. In some awareness all of these institute the rules of business but they haven’t shielded a very important aspect, the set of rules that determine how a business operates and that is the rules that prevent, cause, or suggest things to happen.

References:

Garcia, T. I. and L’Orange, H. P. (2010). Strong
Foundations: The State of State Postsecondary
Data Systems. Boulder, CO: State Higher
Education Executive Officers (SHEEO)