Reference no: EM133722732
Instruction
Do the following problems from the book:
Question 1: What does the term data independence mean, and why is it an important goal?
Question 2: For each of the following pairs of related entities, indicate whether (under typical
circumstances) there is a one-to-many or a many-to-many relationship. Then, using the shorthand notation introduced in the text, draw a diagram for each of the relationships.
STUDENT and COURSE (students register for courses)
BOOK and BOOK COPY (books have copies)
COURSE and SECTION (courses have sections)
SECTION and ROOM (sections are scheduled in rooms)
INSTRUCTOR and COURSE
COURSE and SEMESTER
MEAL and COURSE
4: try two or three drawings. You may have been assigned a CASE or a drawing tool to develop conceptual data models. Using this tool, attempt to redraw all the E-R diagrams in this chapter. What difficulties did you encounter? What E-R notations did not translate well to your tool? How did you incorporate the E-R notation that did not directly translate into the tool's notation?
For question 4- In our class, we will be using MySQL which has features that can be used to accomplish this task. However, if MySQL is used you actually have to build
tables and enter some data elements in order to get the relationships to work - you can try it if you would like. We will explore how to do this later in the class.
Remember, please do not copy anything or you will be removed from the course. No plagiarism is allowed.
Options for answering the question -
Use drawing tools in Microsoft Word
Use drawing tools in Microsoft PowerPoint
Use other drawing software
Draw.io - free drawing software