- Perform mapping to transform the EER into relations.
Brief item decscription
- Perform mapping to transform the EER into relations.
- Perform normalization:
- Show relations in 1NF
- Show relations in 2NF
- Show relations in 3NF
- SQL Tables showing your project.
Running head: LOCAL COLLEGE DATABASE SYSTEM LOCAL COLLEGE DATABASE SYSTEM
October 14, 2016 1 LOCAL COLLEGE DATABASE SYSTEM 2 LOCAL COLLEGE DATABASE SYSTEM
Description of the organization
The Colorado Springs Campus is a local academic institute in Colorado, United
States. It is only single local college in Colorado Springs provides you the personalized
attention and career-centered training an scholar prerequisite to kick-start a healthier career
quicker. The recently modified, 21,000-square-foot amenity has been structure to support you
acquire the maximum out of the scholastic experience. The college place features a 65-seat
theater, 20 classrooms, four computer labs and three medical labs. In adding, the local college
campus of the organization comes well-found with Wi-Fi service, so that one will have
complete access to the facility of the Internet, in addition to the instructors can convey
dynamic online assets into the classroom. All the faculty associates have had practical
experience undertaking the kind of effort you could acquire to ensure when one graduate.
Description and Purpose of the Database (ER Diagram)
We provide the description of the database system for the local college institute that
support the college administration to keep the track record of the students, courses offered
and they take admission to as well as maintain the complete data of the instructors(faculty)
teaching in the particular courses. The database comprises of the data records about the new
and existing the new and existing students, faculty or instructor offers teaching into the
courses offered in the local college with number of departments or classes respectively. The
purpose of a local college as organization?s database is to help people keep track of things. It
accomplishes this purpose by storing data in tables. Each table has rows and columns, similar
to an Excel spreadsheet. A database usually has multiple tables in order to keep track of
different by related things. For example, we might have a STUDENT table to keep track of
students and a FACULTY table to keep track of the instructor data we administer. Each row LOCAL COLLEGE DATABASE SYSTEM 3 in each table holds data about a particular instance, i.e., one student and instructor. The
database also stores the links between the tables, so that we can track which student details
like roll no, id, courses and department etc. [Raj101].
Entities and Attributes of the EER Diagram for Colorado Springs Campus
Entities of the database are: Student, Faculty, Class, Courses, and Classroom, EnforceSince.
Attributes: Student: StudentID (Primary), Name, Address, Grade, Section No, Password.
Faculty: FacultyId (Primary), Faculty Name, Address, Password, DeptId.
Courses: Course Name, Id (Primary), DeptId (Foreign key), Semester offered, credit hours.
Class: Section No (Primary Key), Year (Primary Key), Semester (Primary Key), and Class time, Enrollment, Max Enrollment, and Text Book.
Class Room: Classroom ID (Primary Key), Seats.
EnforceSince Entities and their attributes of the college database (E-R diagram of the Colorado Springs
Campus College Database) LOCAL COLLEGE DATABASE SYSTEM 4 Fig. 1 an Entity-Relationship Diagram for a Colorado Springs Campus Database
Conceptual Model and Physical Model of the database
The conceptual model of the database of the local college must include the information
that identifies the highest level associations amid the different entities of the database system.
The conceptual model comprises of these data features:
1. It comprises the significant database entities and the respective relationships between
them. For example, entity Student related to the entity Course as the student whether
new or existing in the college records has a one-to-one (one-to-many) relationship.
Each of the student must take admission in one course into a particular department.
Whereas Faculty (Instructor) has a relationship with Course and Class entities as
each of the instructor must study atleast a single course in the particular department of
the local college.
2. The most important entities that shows in the conceptual model are student, faculty,
and course with their respective attributes.
3. In this view or model, primary keys are not detailed explicitly in the database e.g.
course Id, student Id etc.
4. No attributes of any database entity is illustrated in the conceptual model.
The physical model of the local college database has several entities and related
attributes. The model has information about the entities and relationships amid them. The
model shows the information that a local college comprises of a number of departments. Each
department has numerous courses. A number of class mark up every offered course. Students
register in a specific course and yield course offered in particular class concerning the end of LOCAL COLLEGE DATABASE SYSTEM 5 the course. Each class has faculty each having a particular course taught by a faculty or
instructor from the suitable department, in addition each faculty teaches a group of students.
The physical model displays all table structures, comprising column data type, column name,
primary key, column constraints, foreign key, in addition to relationships amid tables
[Mic101]. Works Cited
Chopra, R. (2010). Database Management System (DBMS)A Practical Approach. S.Chand
Malcher, M. (2010). Oracle Database Administration for Microsoft SQL Server DBAs.
McGraw Hill Professional. . LOCAL COLLEGE DATABASE SYSTEM 6
Notice: Undefined index: payment_status in /home/aceyourh/studycourse.fun/wp-content/themes/premier/page-templates/paper-detail.php on line 248
About this question:
This question was answered on: Oct 14, 2020
This attachment is locked
We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)
Notice: Undefined variable: ip_country in /home/aceyourh/studycourse.fun/wp-content/themes/premier/page-templates/paper-detail.php on line 456
Need a similar solution fast, written anew from scratch? Place your own custom order
We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.