top of page

Database Design And Implementation Help Using SQL Server



Project Requirement

In this you can use company database of any other from your choice.


This task is divided into 3 parts:


Task 1:

  • Data Modelling Diagram(s)

  • Entity Relationship Diagrams

  • Semantic Object Diagram

  • Relational Tables

  • Normalization tables

  • Data Flow Diagram(s) (including context level, level-0 and level-1)

  • Data Dictionary

  • Use Case Diagram(s) and/ Activity Diagram(s)

  • Class Diagram(s)


Necessary Requirements:

  • Entity Relationship Diagrams provided and drawn correctly

  • Entity Relationship Diagrams were consistent with proposed solution

  • Normalize tables into 1 NF

  • Normalize tables into 2 NF

  • Normalize tables into 3 NF

  • Relational Table Diagram Provided and drawn correctly

  • Relational Table Diagram corresponds with ERD

  • Semantic Object Diagram(s) were provided and drawn correctly

  • Semantic Object Diagram(s) are consistent with proposed solution

  • Data Flow Diagram(s) (including context level, level-o and level-1) were provided and drawn correctly

  • Data Flow Diagram(s) were consistent with proposed solution

  • Data Dictionary was provided and drawn correctly

  • Data Dictionary was consistent with proposed solution

  • Use Case Diagram(s) provided and drawn correctly

  • Use Case Diagram(s) were consistent with proposed solution

  • Activity Diagram(s) were provided and drawn correctly

  • Activity Diagram(s) were consistent with proposed solution

  • Class Diagram(s) were provided and drawn correctly

  • Class Diagram(s) were consistent with proposed solution


Task 2:

  • Create databases

  • Create tables

  • Add and delete records

  • Apply constraints on the columns

  • Create indexes

  • Create relationships

  • Create views

  • Query data using a view

You need follow:

  • Create tables

  • Assign appropriate data types

  • List of validations (8) to be applied on tables

  • Apply 8 validations

  • Create relationships

  • Apply relationship constraints

  • Insert records into the tables (At least 5 records in each table)

  • List of views to be created

  • Create 6 views

  • Create SQL query(s) to insert records

  • Create SQL query(s) to update records

  • Create SQL query(s) to delete records

  • Create SQL query(s) using wildcards

  • Create SQL query(s) using criterion involving a text field

  • Create SQL query(s) using criterion involving a numeric field

  • Create SQL query(s) using compound criterion (AND, OR, NOT)

  • Create SQL query(s) using multiple functions in the same command

  • Create SQL query(s) to group records

  • Create SQL query(s) to Sort results

  • Create SQL query(s) to join tables


Task 3:

  • Write functions ,

  • procedures,

  • triggers

What is necessary:

  • Explanation of at least 4 stored procedures including insert , update , delete and select queries

  • Use of input parameters in stored procedures

  • Use of output parameters in stored procedures

  • Use of default values in stored procedure

  • Execute code for stored procedures

  • Create reports based on functions created above

  • Create reports based on stored procedure created above

  • Create a report that demonstrates parent-child relationship

  • Create a report that demonstrates group by clause

  • Format reports appropriately

  • Create at least 1 trigger


Comments


bottom of page