Question

Book: Systems Analysis and Design in a Changing World, 7th Edition 3. Consider the domain model...

Book: Systems Analysis and Design in a Changing World, 7th Edition

3. Consider the domain model class diagram shown in Figure 4-16—the refined diagram showing course enrollment with an association class. Does this model allow a student to enroll in more than one course section at a time? Does the model allow a course section to contain more than one student? Does the model allow a student to enroll in several sections of the same course and get a grade for each enrollment? Does the model store information about all grades earned by all students in all sections?

4. Again consider the domain model class diagram shown in Figure 4-16. Add the following to the diagram and list any assumptions you had to make: A faculty member usually teaches many course sections, but some semesters, a faculty member may not teach any. Each course section must have at least one faculty member teaching it, but sometimes, faculty teams teach course sections. Furthermore, to make sure that all course sections are similar, one faculty member is assigned as course coordinator to oversee the course, and each faculty member can be the coordinator of many courses.

5. If the domain model class diagram you drew in exercise 4 showed a many-to-many association between faculty member and course section, a further look at the association might reveal the need to store some additional information. What might this information include? (Hint: Does the instructor have specific office hours for each course section? Do you give an instructor some sort of evaluation for each course section?) Expand the domain model class diagram to allow the system to store this additional information

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Book: Systems Analysis and Design in a Changing World, 7th Edition 3. Consider the domain model...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Draw the domain class diagram for the following question. You should identify the necessary classes and...

    Draw the domain class diagram for the following question. You should identify the necessary classes and the types of relationships connecting them, in order to closely model the provided information. Include the names, role names, and multiplicities for all associations. Provide the directionality for the aggregations and reflexive associations, if you use them in your diagram. Identify at least two attributes for each class. Methods are not required. Question: At a university, courses are offered as course sections, and a...

  • Please build an Entity Relationship Diagram using the following information: Build a database for a regional...

    Please build an Entity Relationship Diagram using the following information: Build a database for a regional university in Western New York called Ithica South University. The university database administrator needs to keep track of the students that attend the university, the courses offered by the university, and the university employees. Ithica tracks the first and last name of each student, as well as their target degree. The university keeps track separately of two subclasses of students, as students are either...

  • Read, read and read and then think about that you can create perfectly an enhanced ERD...

    Read, read and read and then think about that you can create perfectly an enhanced ERD for the following description. with making sure to include all kind of entities, attributes, and correct cardinality in relationships between entities. Never forget foreign keys. You need to build a database for the Good College. The College database administrator needs to keep track of the students that attend the College, the courses offered by the college, and the college employees. College tracks the first...

  • system analysis and design Class Diagram Scenario An instructor consists of name, address, email, number, and...

    system analysis and design Class Diagram Scenario An instructor consists of name, address, email, number, and salary. There can be either a full-time or part-time instructor. A student consists of name, student number, and email. Students can enroll for at least one seminar in a semester. Each seminar consists of seminar name, seminar number, and fees. Full-time instructors are responsible for taking the seminars. Each seminar can be taken by at least one and at most two instructors. Only two...

  • Create an Entity-Relationship Diagram (ERD). In the ERD include the following:

    Create an Entity-Relationship Diagram (ERD).In the ERD include the following: entities primary keys for all entities attributes - use "good" names for attributes, use only single-valued attributes relationships - use Crow's foot or UML notation; name relationships that could be ambiguous cardinality - minimum (optional/mandatory) and maximum (one or many) on both ends of the relationship - use reasonable assumptions if there is insufficient information in the descriptionStudent/Course registration system for a universityStudents have a unique identification number, first name, middle initial, last name, year...

  • You have been approached by a University for the design and implementation of a relational databa...

    You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database design process provided the following data requirements for the University Database system. Using the following requirements answer this...

  • SYSTEM ANALYSIS AND DESIGN CLASS ... ( HELP PLEASE I NEED THIS NOW......I WILL RATE!!!!) Chapter...

    SYSTEM ANALYSIS AND DESIGN CLASS ... ( HELP PLEASE I NEED THIS NOW......I WILL RATE!!!!) Chapter 8 Homework (DIAGRAMS NEEDED) PLEASE!!! Scenario: Sweetbriar College is redesigning their course registration system [CRS]. They plan for this system to be web-based, but first you need to model the main system behind the web interface. Here is a description of the interactions with the proposed CRS. Faculty enter courses into the system, assign section numbers, instructors, dates, times, and classrooms for individual instances...

  • Part. II Please draw ER Diagram and write relational data model for the following business. 1....

    Part. II Please draw ER Diagram and write relational data model for the following business. 1. IT Training IT Specialists is a company to provide IT courses in programming, database development and Web applications. Business rules include: » Each course is identified by a unique course number (cNo) and other course attributes include: course name (cName), course description, pre-requirements . At least one and up to many sections can be offered by each course. » Each section is identified by...

  • 4. Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the Student table? b. How would you remove the Registration table? c. How would you change the FacultyName field from 25 characters

    Problems and Exercises 1 through 9 are based on the dass scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.4. Write SQL data definition commands for each of the following queries:a. How would you add an attribute, Class, to the Student table?b. How would you remove the Registration table?c. How would you change the FacultyName field from...

  • (MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications...

    (MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT