Database Systems

Hans-Petter Halvorsen

1 2 3

Schedule Week Assignment Textbooks Quiz Q&A Previous Next 

×

Database Systems - This week's Highlights

 

Database Systems: This weeks topic is Database Design, Modelling and Implementation. We will use ERwin for Datbase Design and Modelling. Then we will implement our database model in SQL Server.

 

You need to know about the following (known from previous courses):

  1. ERwin
  2. SQL Server and basic SQL (Structured Query Language)
  3. How we can communicate with a SQL Server database from Visual Studio (using ADO.NET).

Database Modeling (ERwin), SQL Server and Database Communication with C# (using ADO.NET) should be known from previous course, but since these 3 topics are crucial for our project, there will be a short repetition of these topics with some hands-on examples. In addition, basic knowlede of the Structured Query Language (SQL) is necessary knowlede for this project. See also SQL Server and ADO.NET.

 

Software: Make sure to install both ERwin and SQL Server in advance, otherwise you cannot follow the examples and tasks given in class! You need to apply for ERwin - so it may take 2-5 days before you are able to use it!

 

For more details, see the Week Assignment.

1. Preparations

2-3h. Main focus: Prepare to participate in class activities. It is important that you are prepared when you come to class. 

Database Systems - This week's Highlights

 

Software

You need the following Software (make sure to install them before you come to class!):

(You will need more software later)

 

Note! In class we will need to use the software mentioned above. Installing software is time consuming! Don't waste your, the group or the teachers time in class. Make sure to install it before class. If you don't have the software ready for class, you cannot keep up with the practical exercises and project work that you should do in class.

 

Resources

Please go through the resources below before you meet in class.

Database Systems

Video: Introduction to Database Systems:

PowerPoint used in the Video

 

Database Modelling

Video: Database Modelling with ERwin:

PowerPoint used in the Video

 

SQL Server

Video: SQL Server:

 

Structured Query Language (SQL)

Do you need to refresh your skills in SQL? Here are some good resources:

SQL Tutorial - Basic SQL Training from w3schools.com

 

ASP.NET Core

Video: ASP.NET Core - Database Communication:

PowerPoint used in the Video

This video is also available on my Youtube Channel (Industrial IT and Automation).

Click here in order to see more ASP.NET Core Videos and Download Examples.

 

 

Textbooks

The theory part of this course is "reading material" (it's like reading a novel), so be sure to take a look at some of the textbook resources below, and especially the Sommerville book. The main concept in this course is to read the theory at home and then apply the theory concepts on the project.

Software Development Literature

 

Read the following chapters in one ore more of the following Textbooks below before you meet in class:

Textbook Syllabus
Software Development - A Practical Approach
  • Ch.25: Databases
Software Engineering (I. Sommerville)
  • Ch.2.2.2
Essentials of Software Engineering (Frank Tsu et al.)
  • Ch.7 (7.3.2)
  • App.C: SDD Document
Software Engineering (Saikat Dutt, et al.)
  • Ch.3: Req. Analysis Modeling

2. Activities in Class

6h. Main focus: Practice applying key concepts with feedback. Execution and review of the week assignment will be the main focus in class on Tuesdays and Fridays.

 

Review: Upload the Software Requirements and Design (SRD) document to Microsoft Teams/Canvas. You should have started to use Azure DevOps in your project. Make also sure that you have given access to HPH.

 

Week Assignment

It is important that you do what's in the weekly assignments. The weekly assignments guides you through the course with a red line with a primary focus on important topics in software engineering and practical implementation of these topics through a large project. The contents of the week assignments are important criteria when it comes to censorship and grading in this course. 

Main Tasks in Week Assignment this week:

  1. Design your Database with ERwin.
  2. Then, implement your database model in SQL Server using a Table Script generated from ERwin.
  3. Finally, Create a Proof of Concepts (PoC) where you create code examples for communication with the SQL Server Database from your Application using ADO.NET, preferably an ASP.NET Core Web Application. When creating the examples use the Source Code Control features in Visual Studio and Azure DevOps.

 

Quiz:

Friday Afternoon Quiz - Can you relax this weekend? - or do you need to take an extra look at some of the available resources? In order to Pass this Quiz, you need to get a Score >= 70%. You should answer the questions without any aids!

 

3. Complementary Work

6-7h. Main focus: Finish Week Assignment. Check your understanding and extend your learning. Go through the following resources in order to review and get a deeper understanding of what you should learn in this topic. You may also need these resources in order to solve the week assignment.

 

Documents

It is recommended that you read the following documents:

Structured Query Language

 

Videos

It is recommended that you watch the following videos:

Video: Database Views and Stored Procedures:

PowerPoint used in the Video

 

Video: Database Development:

PowerPoint used in the Video

Download Database Script Generator used in the Video. You need LabVIEW or LabVIEW Run-Time Engine (free)

 

Video: ASP.NET Core - Database CRUD Application:

PowerPoint used in the Video

This video is also available on my Youtube Channel (Industrial IT and Automation).

Click here in order to see more ASP.NET Core Videos and Download Examples.

 

Video: Azure DevOps - Source Code Control:

This video is also available on my Youtube Channel (Industrial IT and Automation).

 

 

Web Resources

Below you find some additional resources for deeper understanding and reflection:

Database Systems

ERwin

SQL Server

 

Database Design Best Practices

Ten Common Database Design Mistakes

Database Design Rules

 

Review

Review Questions - Note! This is mandatory! In order to Pass this Quiz, you need to get a Score >= 50%.

In order to get best outcome, you should answer the questions without any aids! You should also write your answers in your own words using Norwegian language. Don't just copy the text directly from the PowerPoints or the Textbooks, in that way you dont learn anything! When answering the Questions, pretend you are sit down taking the final written Exam. This means you should watch Videos, read the Textbooks, PowerPoints and oher Resources in advance before you start answering the Review Questions.

Questions and Answers (Q&A)

In this Forum everybody can ask Questions, answer Questions, give Tips and Tricks, etc. regarding Software Development. Please use Full Name and Picture.