| |
|
CS6360 Database Design
|
|
| Instructor: John Cole | Section MS1 on Friday evenings; see schedule |
| Office and Hours | Online |
|
Teaching Assistant: |
Last update: 12/19/2020 |
| Syllabus is on Coursebook | Schedule |
| Textbook: Fundamentals of Database Systems, Seventh edition, by Elmasri and Navathe | |
| This is the graduate course in Database Design
for the Executive Master's in Software Engineering program only.
Although material such as SQL will be covered, there will be an emphasis
on the internals of database management systems as well as theory, such as
the entity-relationship model,
normal forms and relational algebra. You will write
quite a bit of code for this course. For a computer
scientist it is not enough to understand how to use a database manager; you
must understand how to write one, as well. You can use any DBMS you like, but I will be using Microsoft SQL Server Express. | |
|
Code to connect to SQL Server |