Project #45575 - System Analysis and Design

1. Following information has been collected from a JRP session where the

Department Chairpersons and Principal teachers met to come up with requirements for building a data model for all departments of their college:

• A course is offered many times and each offering belongs to one

course

• There is one principal teacher per department and every department

is managed by a principal teacher

• A teacher can teach many different courses and each course can be

taught by many teachers

• Each teacher may be involved in non-‐teaching projects and courses

may have not yet been assigned a teacher

• A course may have other courses as prerequisites and each course

may be a prerequisite to many other courses

• A teacher can have many students and many courses can be taught

by a teacher. Every registered student has to take a course.

1. Identify all the entities in the above scenario (10 points)

2. Define attributes of each entity (10 points)

3. Draw Cardinality diagram for each bullet point above (10 points)

4. Resolve all the many to many relationships by resolving them into First, Second and Third Normal Forms. (20 points)

2. An Online Movie Rental Company allows members to play or watch

movies.

Following are the use cases they have defined.

• Register new customer

• Member Sign in

• Browse for Movies

o Search by genre

o Search by actor

o Search by director

o Search by movie

• Watch selected movie

• Add movies to the queue

• Ship DVD

• Check for return of DVD

• Send next movie in the queue

1. Identify all the actors in the above scenario (10 points)

2. Categorize each actor in to one of the 4 types: Primary Business, Primary System, External Server and External Receiver (10 points)

3. Draw a use case diagram with actors and use cases using extends, includes and depends on relationships. (30 points)

Subject Computer
Due By (Pacific Time) 11/05/2014 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy