Readme for Lecture Notes for CSCI 3410 – Database Systems

Clément Aubert

October 5, 2020 (12:19:25 PM)

Here are the lecture notes, codes, exercises, problems and references for a lecture on database taught at Augusta University by C. Aubert. The webpage for this project is at https://spots.augusta.edu/caubert/db/ln/, and it contains a compiled version of the notes.

Getting Started

The source code, hosted at https://rocketgit.com/user/caubert/CSCI_3410, is organized as follows:

.
├── install/                -- Installing the requirements to compile the document.
├── notes/                  -- The notes themselves.
│   ├── bib/                -- References (including reference to the document).
│   ├── code/               -- Source code included in the document.
│   ├── fig/                -- Source code for various figures.
│   ├── filters/            -- Pandoc filters.
│   ├── img/                -- Various image files integrated in the document.
│   ├── latex/              -- Latex configuration file.
│   ├── lib/                -- Various libraries
│   ├── style/              -- css style used for the web page.
│   ├── example.md          -- An example file, to test your installation.
│   ├── lectures_notes.md   -- The main file for the lecture notes.
│   ├── Makefile            -- Directives to generate the lecture notes.
│   └── temp.md             -- Temporary file, for debugging purposes.
├── CONTRIB.md              -- A guide on how to contribute.
├── KNOWN_BUGS.md           -- A list of possible bugs, improvements, …
├── LICENSE.md              -- The license of those notes.
└── README.md               -- The present file.

Before compiling this document, you will need to install git, LaTeX, pandoc, some of pandoc’s filters, and several other programs. Refer to install/INSTALL.md for instructions on how to compile this document, and to notes/example.md for an example file.

To clone the source, use git and the command

git clone https://rocketgit.com/user/caubert/CSCI_3410

To compile this document, simply change directory to notes and run

The Makefile in the notes folder is commented.

Contributing

The simplest way to contribute is to report typos, errors or misleading statements. You will find some instructions at CONTRIB.md if you’d like, but you can…

Authors and Contributors

Those notes would not have been without the constant support, curiosity, and remarks from my students. Crystal was supported by an Affordable Learning Georgia “Mini-Grant for Ancillary Materials Creation and Revision” (Proposal M71). Bobby, Minh and Poonam benefited from the support and guidance of Dr. Onyeka Ezenwoye in the CSCI 4712 - Senior Capstone Project class.

License

This project is licensed under the CC BY 4.0 licence: you are free to share and adapt this document, as long as you give proper credit. Refer to LICENSE.md for the complete licence.

The following files have different licences, and have other authors:

Those files are redistributed as is, in agreement with their respective licences.

The file notes/fig/er/template.def was inspired by the tikz-er2 package, available at https://bitbucket.org/pavel_calado/tikz-er2/src/default/.