DATABASE DESIGN


About

All good Projects start with Database Design! Database Designing is the process of creating a data model (ERD) which in turn supports your whole project. A good database design ensures consistent data and less data redundancy. By taking time to design the database we can remove the levels of frustrations faced during the project. This challenge consists of two rounds. In the first round, contestants will be presented with a problem statement and data. From this, they will be required to design a working database solution and implement specified components of that database using SQL. For the second round, students will be tested with their analytical abilities to prepare an Entity Relationship Diagram (ERD) for a complex scenario. Database design needs a thorough analysis of the given scenario. SQL queries may seem tough but they are the real game changers for a faster query results in a faster result. Are you ready to build a game changer?

Competition Design

The competition will be comprised of two rounds.
Round 1: Participants will be required to formulate queries for the given questions, according to the given schema and data.
Round 2: Participants will be given a detailed scenario and they will be required to construct an ERD accordingly.

Judgement Criteria

Correctness and efficiency of queries, relevance of design.

Rules

  • No external storage or communication device will be allowed.
  • No software other than the mentioned one can be used.
  • Any notes for reference will not be allowed.
  • Use of internet is not allowed
  • Design can be submitted on paper
  • Any team caught using unethical means will be disqualified immediately

  • Databases:

    SQL server, oracle 12c , MYSQL and Mongodb(nosql)

    Designer tools:

    dbdesigner , ms visio.

    Best of luck!


    Event Head:

    Shehr Banu Karim

    Event Head Details:

    03322994913

    shehr.banu@khi.iba.edu.pk