Git Product home page Git Product logo

dmau1-exam-exercises's Introduction

DMAU1-exam-exercises

This repository contains tentative English translations of exam exercises, stemming from Sapienza’s "Basi di dati" course, running from 2015 until 2019.

The original authors include Professors Marsico and Professor Mancini.

These files are provided to the students of "Applied Computer Sciences and Artificial Intelligence" attending Prof. Mancini’s "Data Management and Analysis, Unit 1" course.

As these translations likely include errors, feedback’s welcome.

ADOC

Note
 plain text .adoc files contain the translations’ sources, adoc is short for Asciidoc.

adoc files can be read by any browser with the relevant extension.

You can print all the repository’s adoc files by running print_all.py, in this same repository, provided Asciidoctor Web PDF is installed and its path is configured in the script’s source.

A sample style sheet is provided.

PDFs

Download print-ready PDFs from the release section.

Note
 PDFs are produced thanks to Asciidoctor Web PDF.

dmau1-exam-exercises's People

Contributors

silktrader avatar mauman avatar davide-f5-marincione avatar

Stargazers

avatar

Watchers

avatar avatar

Forkers

davide-f5-marincione

dmau1-exam-exercises's Issues

Add `Title` to `PERFORMANCE` key in 2016-07-04 Exercises

The first exercise proposes a relation that possesses three tables, representable with the following E/R model

Relation_wrong

It is clear therefore that the table Performance is meant to be a Join table between the Theatre and Play tables, representing their N to N relationship

This is however problematic in the way that it's key is implemented: when creating a join table, it must have as keys two foreign keys coming from the primary keys of it's "parents", namely Theatre and Play, however we should also keep date, since we want the same performance to be played more than once

Solution: Simply make title a key as it's supposed to be while also keeping date as a key:
Relation_right

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.