Code: E371079
Range: 3+1, 5 credits, finished by examination
Lecturer:
Ing. Vladimír Hlaváč, Ph.D. (hlavac@fs.cvut.cz)
Pallaw,
Vijay Krishna: Database Management Systems
(this book is available for the Czech Technical University
students, using this link, but only from the university
computers. It can be read in computer classrooms - for example,
room 405a (computers for individual work), or by notebooks in the
Technická 4 building in Dejvice using WiFi with user logged into
Fsroam.)
Isrd
Group: Introduction to Database Management Systems
(can be read from the Google books, with limited pages per day;
some of the pages are restricted completely, but they are not
needed for our subject).
(both are too extended for the level of this subject)
Prof. Michael Redmond course materials - normalization ppt.
M. Brydon´s MS Access Tutorial.
Prof. Rich Holowczak Access Course
Links to videos about Fuzzy:
short intro: https://www.youtube.com/watch?v=1kW3VA99408
Matlab series:
https://www.youtube.com/watch?v=__0nZuG4sTw
https://www.youtube.com/watch?v=CBTEVFphv-E
https://www.youtube.com/watch?v=fU8Lyc8kzto
https://www.youtube.com/watch?v=MbUaxn-7bJI
software: local copy of the Micka installation (see www.senon.cz for more information about Micka), putty (for ssh connection to server). In the computer classroom 308, use Heidi. Both SQL clients have been written in the same software.
ER diagrams | pdf | ppt2 | (CZ)
SQL advanced II.
Students' presentations
What to upload to Moodle?
Should be submitted handwritten (better to say handdrawen) on a paper.
Text file. Always a plain text, what the proposed command should do, and on the next line the SQL command itself.
All the required tasks should be presented as a result and in the design view. Make the Access window smaller and use Alt+PrtScr. Collect the catched pictures for example in a Word document.
Make a zip file from all the files in the directory.
Upload the pptx (or pdf) file of presentation.
