SOEN 363: Data Systems for Software Engineers Assignment 1

$30.00

Category: You will Instantly receive a download link for .zip solution file upon Payment || To Order Original Work Click Custom Order?

Description

5/5 - (1 vote)

Q 1. [30 pts] Consider a movie database that contains movie and series titles and their
genres, where the titles are uniquely identied by their IMDB IDs [5]. While series many
have one or many seasons, mini-series only have one single season.

Movies made in multiple
parts / episodes are considered as individual movies. For each title (movies or series), only
one genre per title is kept, as well as one director per movie, and up to ve actors per title.

Note that a movie may be directed by one of its actors. While each movie may be tagged
with a few keywords, the system also provide full text search on the movie description and/or
the movie plot.

A) [25 pts] Design a data model that captures the above description. Identify the entities,
relations, attributes, keys, and their cardinalities. Identify strong and weak entities and
relations, if applicable. Represent the end result in the form of an ERD diagram, using
chen notation [2].

B) [5 pts] Provide a database instance that demonstrate a documentary movie that is
self directed by a single actor.

Q 2. [50 pts] Consider the following system description:
Consider a multi-storey long term parking garage. Vehicles are assigned to single
spots and a spot can only accommodate a single vehicle. The parking management keeps a log of the cars that are parked. Upon entering the garage, the
system will allocate a vehicle to a spot and upon leaving the garage, the system
will deallocate that vehicle from its spot, thus making that spot available.

A) [30 pts] Design a data model that captures the above description. Identify the entities,
relations, attributes, keys, and their cardinalities. Identify strong and weak entities and
relations, if applicable. Represent the end result in the form of an ERD diagram. Use
single arrow – no arrow notation for cardinalities and single line – double line for partial
and total participations [1].

B) [5 pts] Provide the schema and explicitly identify the domains of each attribute.
C) [5 pts] Provide the DDL script for the above.

D) [10 pts] Provide a database instance that demonstrate three locations: one empty
(never occupied), one occupied, and another one that is currently free but previously
had been occupied. Indicate the cardinality and the degree (arity) of each relation in
the instance.

Q 3. [20 pts] Represent the ERD of either questions in crow’s foot notation using PlantUml
[3], [4].
Submit your assignment electronically on Moodle: https://moodle.concordia.ca
Include your name and student ID in the submission. Make sure that you upload the
assignment to the correct assignment box on Moodle. No email submissions are accepted.

Assignments uploaded to the wrong system, wrong folder, or submitted via email will be
discarded and no resubmission will be allowed. Make sure you can access Moodle prior to
the submission deadline. The deadline will not be extended.

References
1. https://jcsites.juniata.edu/faculty/rhodes/dbms/ermodel.htm
2. https://vertabelo.com/blog/chen-erd-notation/
3. https://vertabelo.com/blog/crow-s-foot-notation/
4. https://plantuml.com/ie-diagram
5. https://imdb.com