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?
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.
Correctness and efficiency of queries, relevance of design.
Databases:SQL server, oracle 12c , MYSQL and Mongodb(nosql)
Designer tools:dbdesigner , ms visio.
Best of luck!
Shehr Banu Karim
Event Head Details: