Database Systems Design Implementation and Management 13th Edition pdf free download

The textbook for this course will be:

Database Systems - Design, Implementation, and Management, 13th Edition Carlos Coronel and Steven Morris ISBN-10: 1337627909 ISBN-13: 978-1337627900

This text is a thorough, up to date (2019) treatment of the topic. It is available from Amazon and th publisher (Cengage.com). Note: if you obtain the text (in any form) you do not need the “MindTap” version.

Documentation for many of the tools we will be using will either be found in  man pages or are supplied as URL’s below. Of course, you’re welcome to employ your favorite search engine to find them yourselves.

Other resources, papers, and references will appear on in this page as they are identified.

If you find tools or references that you like, mention them on Slack to share with everyone.

Course resources

• The Student Data Files which contain all the source code used in the text is available here.

  You do NOT need to purchase anything at this site. If you click on the “Errata” and “Student Data Files” links (in blue on the left) you can download all the student materials.

  The textbook’s authors provided several sample databases for you to use. They are in Microsoft Access databases, so you will need to run a quick shell script to convert those .mdb files to sql files. The script is available here: mdb_to_sql.sh .

• Database Programming Samples
  • You are expected to use Python for all your programming assignments.
  • We are providing an example using Python to access the class MySQL server at Dartmouth.
  • We are also providing an example using Python to access the class MongoDB server on MongoDB Atlas.
• Online references
  • MySQL reference manual, for Version 8, which is what we will be using.
  • MySQL’s connector for Python may be found here, and all the other Connectors and API’s are there too.
  • W3Schools.com’s SQL Tutorial covers SQL for a variety of systems, including MySQL. It has loads of live examples as well as a good reference section.
  • The MySQLTUTORIAL website has a good MySQL with Python tutorial as does the TutorialsPoint website.
• Other language references that may be useful with MongoDB
  • PHP function reference.
  • Javascript tutorial at w3schools.
• Papers
  • Several seminal, interesting papers may be found here. They are recommended to all students who want to learn more.
  • This paper from Kent provides a great explanation of the Five Normal Forms (third week).
• Books
  • Database Systems: The Complete Book (2nd Edition) by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom; Prentice Hall, 2008. Referred to as DSCB.
  • PHP and MySQL is an excellent book by Joel Murach & Ray Harris. It’s available as a big paperback as well as an eBook.

• Useful tools

  • Relational Algebra tools

    • Relax Relational Algebra calculator This is an excellent tool for exploring Relational Algebra. It can evaluate any relational algebra expression like σa>42 ( A ) ⋈ ( Π a,b ( B ) )

      over a set of relations you can define. The examples demonstrated in class use this tool.

      You can create relations by hand or bulk load them. See the Readme.

    • RA The RA Relational Algebra interpreter, maintained by Prof. Jun Yang at Duke University, is a handy aid to learning about relational algebra.

  • SQL and Relational DB tools

    • MySQLWorkBench is an open source integrated environment including tools for SQL development, DB design and modeling (including E-R diagrams), and DB administration. MySQLWorkbench makes it easy to access remote MySQL servers (like ours) for database creation and SQL querying. We will briefly cover its use in class. It is available for OS X, Linux, and Windows. Note: the current version (6.3) is not yet compatible with Mac OS High Sierra. Use 6.1.7 instead, downloadable here .
    • DBeaver is an open source integrated SQL development environment including toolsfor SQL development and DB administration (but no ERD drawing). DBeaver is compatible with Mac OS High Sierra. This tool makes it easy to access remote MySQL servers (like Ours) for database creation and SQL querying. The DBeaver tool is actively being maintained.
    • draw.io is a handy drawing tool you can use online or as a download.
      It does have templates for ERD as well as lots of others.
    • SQLFiddle is described as “A tool for easy online testing and sharing of database problems and their solutions.” You can enter schemas and data and then launch queries against them, using MySQL or any of the other most popular database systems (PostgreSQL, MS SQL Server, Oracle, and SQLite). It’s a great tool for quick experimentation when you don’t have access to a live DB. It also has the ability to save what you enter as a private problem space (unique URLs) that you can then share with others for consultation or advice.
    • SQL Pro Quick Guide (IOS app) is a very handy reference for SQL , including language syntax, data types, and all sorts of SQL statements and functions.

  • NoSQL Tools

    • MongoDB
      • “NoSQLBooster for MongoDB (formerly MongoBooster) is a shell-centric cross-platform GUI tool for MongoDB v2.6-6.0, which provides comprehensive server monitoring toolsserver monitoring tools, fluent query builder, SQL query, ES2017 syntax support and true intellisense experience.”
      • Studio 3T (a.k.a.) RoboMongo
        A FREE MongoDB GUI with embedded mongo shell. Available on Windows, OS X, and Linux. Go to the link above and choose Download Robo 3T.
      • MongoDB Compass A FREE MongoDB GUI from the MongoDB team. Available on Windows, OS X, and Linux.
      • jq is a lightweight and flexible command-line JSON processor. Very powerful and fast! Installable on Mac’s via homebrew and also available for Linux and Windows.
      • JetBrains’ Pycharm tool has a MongoDB Explorer. Students get a deep discount (perhaps even free). It works, but it take a bit of poking around to get it properly configured.
    • Miscellaneous
      • python itself has a JSON prettyprinter. Use it like this:

        cat myfile.json | python -mjson.tool > myfile.json.text
        

Remember that we’re not suggesting you buy or rent any books other than the text.