MIS602 Data Modeling and Database Design: Programming Evaluation

This assignment solution demonstrates practical database design and SQL programming skills. It begins by creating tables for employees, departments, and salaries, defining primary and foreign keys, and specifying data types. The solution then inserts sample data into these tables, showcasing the use of INSERT statements. The core of the assignment involves writing SQL queries to retrieve and manipulate data, including SELECT statements with various clauses like WHERE, JOIN, GROUP BY, and ORDER BY. The solution also includes a review of the SQL code, highlighting the use of DDL and DML statements. The reviewer provides suggestions for improvement, such as using the LIKE operator and check constraints, and suggests additional resources for learning SQL. Finally, the assignment brief outlines the tasks, including creating tables, inserting data, and writing specific SQL queries to retrieve information from the database. The assignment is designed to evaluate the student's understanding of database design principles and their ability to implement SQL queries to manage and retrieve data.

Running head: DATA MODELING DATABASE DESIGN
DATA MODELING DATABASE DESIGN
Name of the Student
Name of the University
Author Note

1
DATA MODELING DATABASE DESIGN
Overall Usage of SQL
The overall suitability of the usage of the SQL statements are very good. The DDL
statements like CREATE, INSERT and UPDATE has been used properly wherever is required to
use. Table structure, data types, data sizes and primary keys along with the foreign key is
correctly created. Query implementation uses the SELECT statement effectively on the tables
with JOINS, WHERE, GROUP BY, ORDER BY, COUNT and SUM statements. The use of
relational operator and sub query form factor is also used at appropriate places. DELETE
statement is also used well in Task 21. To make the SQL codes visible, in terms of columns, data
types, keys etc., a format is available to write the SQL codes. It is widely used by the
professionals to keep their code clean and easily understandable.
Improve the understanding of SQL
The overall implementation of the Database is done greatly. However, there are some
small details in particular areas which can be neglected or considered in the future. For example,
Task 24 does not provide the results of the desire query. To search any string in a column, LIKE
operator is used in SQL database. Some research about the implementation of the query could
have been provided the instructions on how to use the operator. W3Schools is website that
provide detailed example and implementation of all type of operator and SQL syntaxes (Data,
2011). Also, the spelling of Manager is incorrectly put in the database. Using update it could
have been updated. A check constraint is useful in these types of scenarios. The data consistency
and integrity should be maintain all over the database. Similarly the Task 9 has been done using
separate queries for minimum and maximum salaries. It could have been using AND operator or
UNION operator for the desired results. INSERT statement used in this implementation is good.

2
DATA MODELING DATABASE DESIGN
However, in MySQL it can be done in a single line INSERT statement which require one time
running of the codes.
Some useful readings
To become an experienced programmer and improve the SQL and Database
fundamentals, nothing can be better than the books except for practicing. Practice is done after
learning something. To learn about different variety of syntaxes, their usefulness and where it
can be used. You have to search for the right book or website. W3Schools is a standard website
where the syntaxes can be run online for scenario based queries. To learn there are some books
such as ‘SQL Cookbook: Query Solutions and Techniques for Database Development’ by
Anthony Molinaro (Molinaro, 2005), ‘The Art of SQL’ by Stephane Faroult (Faroult & Robson,
2006), ‘SQL in Nutshell’ by Kevin Kline, Daniel Kline and Brand Hunt (Kline, Kline & Hunt,
2005), etc. On other hand there are several competitive websites where you can solve questions
and SQL problems online. These platforms are HackerRank, CoderByte, Project Euler, etc.
These website provides daily challenges based on a chronological order to learn something from
basic to deep. Several new ideas and solutions can also be identified in these platforms.

3
DATA MODELING DATABASE DESIGN
References
Data, R. (2011). W3Schools SQL Tutorial. Pridobljeno, 1, 2011.
Faroult, S., & Robson, P. (2006). The art of SQL. " O'Reilly Media, Inc.".
Kline, K. E., Kline, D., & Hunt, B. (2005). SQL in a nutshell. O'Reilly.
Molinaro, A. (2005). SQL Cookbook: Query Solutions and Techniques for Database Developers.
" O'Reilly Media, Inc.".