Assignment 1 Business Rules and Data Models
A database is an integrated computer structure that stores end-user data and metadata (Coronel, Morris, & Rob, pg. 7). Data are the raw format of information, which when properly formatted can produce accurate, relevant, and timely information that is the key to making good decisions (Coronel, Morris, & Rob, pg. 5-6). The purpose of a database is to provide computer-based systems a way in which to store, manage, and retrieve data quickly (Coronel, Morris, & Rob, pg. 5). As for a local college database, the purpose of the database will be to house the data of enrolled students, the courses offered and times available, and the information of the faculty. The database can provide possible course matches for each student based off of previous courses taken and pre-requisites obtained, as well as keep track of the professors teaching each course. The database will provide the data a student needs to insure they are taking the correct courses and provide the college and the faculty general student information, such as contact information.
Entities are defined as a person, place, thing, or event in which data is collected and stored. Each entity is a unique and distinct object that may be a physical or abstract object within the real world (Coronel, Morris, & Rob, pg. 34). Entities of a database for a college that needs to keep track of students and courses would be students, professors, courses, classes, room, and enrollment status. These entities will be used to format the data within the database so that each student and course is accounted for. Attributes are characteristics of an entity, such as a name, phone number, or address (Coronel, Morris, & Rob, pg. 34). Attributes for the college database would include student first and last name, student phone number, student address, student identification number, student grade point average, student course major, and student classes to describe the student entity. The professor entity would be described by professor
Entities are defined as a person, place, thing, or event in which data is collected and stored. Each entity is a unique and distinct object that may be a physical or abstract object within the real world (Coronel, Morris, & Rob, pg. 34). Entities of a database for a college that needs to keep track of students and courses would be students, professors, courses, classes, room, and enrollment status. These entities will be used to format the data within the database so that each student and course is accounted for. Attributes are characteristics of an entity, such as a name, phone number, or address (Coronel, Morris, & Rob, pg. 34). Attributes for the college database would include student first and last name, student phone number, student address, student identification number, student grade point average, student course major, and student classes to describe the student entity. The professor entity would be described by professor
References: Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Independence, KY: Cengage.