<?xml version="1.0" encoding="UTF-8"?>
<mods xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/mods/v3" version="3.1" xsi:schemaLocation="http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-1.xsd">
  <titleInfo>
    <title>Database Design</title>
  </titleInfo>
  <name type="personal">
    <namePart>Watt, Adrienne</namePart>
    <role>
      <roleTerm authority="marcrelator" type="text">creator</roleTerm>
    </role>
    <role>
      <roleTerm type="text">author</roleTerm>
    </role>
  </name>
  <name type="corporate">
    <namePart>Open Textbook Library</namePart>
    <role>
      <roleTerm type="text">distributor</roleTerm>
    </role>
  </name>
  <typeOfResource>text</typeOfResource>
  <genre authority="">Electronic textbooks.</genre>
  <originInfo>
    <place>
      <placeTerm type="code" authority="marccountry">mnu</placeTerm>
    </place>
    <dateIssued encoding="marc">2014</dateIssued>
    <edition>2nd Edition</edition>
    <issuance>monographic</issuance>
  </originInfo>
  <language>
    <languageTerm authority="iso639-2b" type="code">eng</languageTerm>
  </language>
  <physicalDescription>
    <extent>1 online resource</extent>
  </physicalDescription>
  <abstract>This second edition of Database Design book covers the concepts used in database systems and the database design process. Topics include: The history of databases Characteristics and benefits of databases Data models Data modelling Classification of database management systems Integrity rules and constraints Functional dependencies Normalization Database development process New to this edition are more examples, highlighted and defined key terms, both throughout and at the end of each chapter, and end-of-chapter review exercises. Two new chapters have been added on SQL, along with appendices that include a data model example, sample ERD exercises and SQL lab with solutions.</abstract>
  <tableOfContents>Chapter 1 Before the Advent of Database Systems -- Chapter 2 Fundamental Concepts -- Chapter 3 Characteristics and Benefits of a Database -- Chapter 4 Types of Data Models -- Chapter 5 Data Modelling -- Chapter 6 Classification of Database Management Systems -- Chapter 7 The Relational Data Model -- Chapter 8 The Entity Relationship Data Model -- Chapter 9 Integrity Rules and Constraints -- Chapter 10 ER Modelling -- Chapter 11 Functional Dependencies -- Chapter 12 Normalization -- Chapter 13 Database Development Process -- Chapter 14 Database Users -- Chapter 15 SQL Structured Query Language -- Chapter 16 SQL Data Manipulation Language</tableOfContents>
  <note type="statement of responsibility">Adrienne Watt</note>
  <note>Publication type: Open textbook.</note>
  <note>Open access; no subscription required for the linked open-access version. Unrestricted online access star</note>
  <note xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="https://open.umn.edu/opentextbooks/textbooks/354">Attribution (licence family recorded by the source; version not supplied in metadata). https://open.umn.edu/opentextbooks/textbooks/354</note>
  <note>In English.</note>
  <subject authority="lcsh">
    <topic>Computer Science</topic>
    <topic>Textbooks</topic>
  </subject>
  <subject authority="lcsh">
    <topic>Databases</topic>
    <topic>Textbooks</topic>
  </subject>
  <subject>
    <topic>B. Sc. Information Systems</topic>
  </subject>
  <subject>
    <topic>UMUN open access collection</topic>
  </subject>
  <subject>
    <topic>Foundational textbook</topic>
  </subject>
  <classification authority="lcc">QA76</classification>
  <relatedItem type="series">
    <titleInfo>
      <title>Open textbook library</title>
    </titleInfo>
  </relatedItem>
  <identifier type="uri">https://open.umn.edu/opentextbooks/textbooks/354</identifier>
  <identifier type="uri">https://open.umn.edu/opentextbooks/textbooks/354</identifier>
  <location>
    <url displayLabel="Read open-access publication">https://open.umn.edu/opentextbooks/textbooks/354</url>
  </location>
  <location>
    <url displayLabel="Open Textbook Library catalogue and formats">https://open.umn.edu/opentextbooks/textbooks/354</url>
  </location>
  <accessCondition type="restrictionOnAccess">Open access; no subscription required for the linked open-access version.</accessCondition>
  <accessCondition type="useAndReproduction">Attribution (licence family recorded by the source; version not supplied in metadata).</accessCondition>
  <recordInfo>
    <recordContentSource authority="marcorg">MnU</recordContentSource>
    <recordCreationDate encoding="marc">180907</recordCreationDate>
    <recordChangeDate encoding="iso8601">20261005174828.0</recordChangeDate>
    <recordIdentifier source="local">UMUN-OA-20261005-IS-004</recordIdentifier>
    <languageOfCataloging>
      <languageTerm authority="iso639-2b" type="code">eng</languageTerm>
    </languageOfCataloging>
  </recordInfo>
</mods>
