Data Systems for Software Engineers Assignment 1

SOEN 363: Data Systems for Software Engineers
Assignment 1
Weight:
5% of the overall grade.

Q 1. [30 pts]
Consider a movie database that contains movie and series titles and their
genres, where the titles are uniquely identied 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 a
Q 2. [50 pts]Consider the following system description:Consider a multi-storey long term parking garage. Vehicles are assigned to singlespots and a spot can only accommodate a single vehicle. The parking manage-ment keeps a log of the cars that are parked. Upon entering the garage, thesystem will allocate a vehicle to a spot and upon leaving the garage, the systemwill 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 andrelations, if applicable. Represent the end result in the form of an ERD diagram. Usesingle arrow - no arrownotation for cardinalities andsingle line - double linefor partialand 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 previouslyhad been occupied. Indicate the cardinality and the degree (arity) of each relation inthe instance.Q 3. [20 pts]Represent the ERD of either questions incrow's footnotation usingPlantUml[3], [4].Submit your assignment electronically on Moodle:https://moodle.concordia.caInclude your name and student ID in the submission. Make sure that you upload theassignment 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 bediscarded and no resubmission will be allowed. Make sure you can access Moodle prior tothe submission deadline. The deadline will not be extended.2
References1.https://jcsites.juniata.edu/faculty/rhodes/dbms/ermodel.htm2.https://vertabelo.com/blog/chen-erd-notation/3.https://vertabelo.com/blog/crow-s-foot-notation/4.https://plantuml.com/ie-diagram5.https://imdb.com3