Question Details

[solution] »

I need assistance with my Lab 4 CIS 111.  I have attached all documents related to this Lab.


Brief item decscription

Answer Download

Item details:

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


Student: William


Professor: Dr. Johnson Kinyua


Course: CIS 111 Introduction to Relational Database Management Systems




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/ on line 248

About this question:

This question was answered on: Oct 14, 2020

PRICE: $20 (18.37 KB)

Buy this answer for only: $20

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)

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.

Notice: Undefined variable: ip_country in /home/aceyourh/ 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.

Order Now