I need assistance with my Lab 4 CIS 111. I have attached all documents related to this Lab.<
I need assistance with my Lab 4 CIS 111. I have attached all documents related to this Lab.
Running head: MODIFYING A DATABASE DESIGN IN DRAW IO, SECTION 2 Lab 2: Modifying a Database Design in Draw IO,
Section 2: Design Summary
Professor: Dr. Johnson Kinyua
Course: CIS 111 Introduction to Relational Database Management Systems
Date: November 31, 2016 MODIFYING A DATABASE DESIGN IN DRAW IO, SECTION 2
2 Modifying the database design in Draw IO requires the addition of attributes that will be
tracked by the college. This diagram reflects an accurate representation of the data relationships
that will incur by such a database. In order to create an accurate diagram, assumptions about
potential business rules had to be made before editing the diagram. The first assumption is that a
student does not have to be enrolled in a class to be in the database. The reason for this, is to
allow for new students who have not registered for classes yet, or for students who had to drop
classes due to different reasons.
This changed the original relationship from many to many to zero to many. Also a course
does not have to have students enrolled to be listed in the database because certain courses are
not offered each semester. This business rule ensures that no data deletion occurs in the course
entity, if it is not offered for a given semester. Another business rule that was considered regards
the relationship between instructor and course. While a course may have one and only one
instructor, if it is not offered during a semester then it will not have one. This requires the
relationship to change from one to one to zero to one. On the other hand, while an instructor can
teach many courses, an instructor is not required to teach any courses making the relationship
zero to many.
This would be especially valuable in the event of an instructor being hired or resigning a
position. This would stop the data deletion in either case to keep record of the various instructors
the school has. While each entity was updated with many attributes, these attributes are not
dependent. With the addition of foreign keys in the course entity, this links all of the included
attributes about a particular student or instructor without the consequences of duplicate data. MODIFYING A DATABASE DESIGN IN DRAW IO, SECTION 2
3 The diagram in Draw io, represents an accurate representation of possible data modeling
and relationships. The diagram could be more detailed and organized with the addition of more
entities and attributes to normalize the database. The addition of new entities and relationships
could reduce the complication of the data while making it easier to access. The Draw io diagram
is a great representation of the relationships between entities and their attributes that will be
needed for the college to access the data.
Notice: Undefined index: payment_status in /home/aceyourh/studycourse.fun/wp-content/themes/premier/page-templates/paper-detail.php on line 248
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.