Your final submission should be three separate files: a technical report including all tasks listed above (for SQL statements, please include both source and output); a diagram file with your ERD (in original format such as .erd for ER Assistant);
Database Design Document
Version X.X
MM/DD/YYYY
Table of Contents
1. Introduction 1
2. Overview 2
3. Literature Review 3
4. Assumptions/Constraints/Risks 4
4.1 Assumptions 4
4.2 Constraints 4
4.3 Risks 4
5. Design Decisions 5
5.1 Key Factors Influencing Design 5
5.2 Functional Design Decisions 5
5.3 Database Management System Decisions 5
5.4 Security and Privacy Design Decisions 6
5.5 Performance and Maintenance Design Decisions 6
6. Detailed Database Design 7
6.1 Data Software Objects and Resultant Data Structures 7
6.2 Database Management System Files 7
7. Database Administration and Monitoring 9
7.1 Roles and Responsibilities 9
7.2 System Information 9
7.2.1 Database Management System Configuration 9
7.2.2 Database Support Software 9
7.2.3 Security and Privacy 10
7.3 Performance Monitoring and Database Efficiency 10
7.3.1 Operational Implications 10
7.3.2 Data Transfer Requirements 10
7.3.3 Data Formats 10
7.4 Backup and Recovery 10
Appendix A: Suggested Appendices 11
Appendix B: Acronyms 12
Appendix C: Glossary 13
Appendix D: Additional Appendices 14
List of Figures
No table of figures entries found.
List of Tables
Table 2 – Acronyms 12
Table 3 – Glossary 13
1.
Introduction
Instructions: Provide identifying information for the existing and/or proposed automated system or situation for which the DDD applies (e.g., the full names and acronyms for the development project, the existing system or situation, and the proposed system or situation, as applicable). Summarize the purpose of the document, the scope of activities that resulted in its development, the intended audience for the document, and expected evolution of the document. Also describe any security or privacy considerations associated with use of the DDD.
2.
Overview
Instructions: Briefly introduce the system context and the basic design approach or organization, including dependencies on other systems. Identify if the database will supersede or interface with other databases, and specifically identify them if applicable. Also identify interfaces with other systems to the extent that they significantly impact the database design. Discuss the background to the project, if this will help understand the functionality supported by the database design contained in this document.
3.
Literature Review
Instructions: Provide summary of related work similar to the project. Your related work summary should capture the purpose for the project and the outcome/recommendations.
4.
Assumptions/Constraints/Risks
4.1 Assumptions
Instructions: Describe any assumptions or dependencies regarding the database design for the system. These may concern such issues as: related software or hardware, operating systems, or end-user characteristics.
4.2 Constraints
Instructions: Describe any limitations or constraints that have a significant impact on the database design for the system.
4.3 Risks
Instructions: Describe any risks associated with the database design and proposed mitigation strategies.
5.
Design Decisions
Instructions: Utilizing the following subsections, describe decisions made that impact the proposed database design. This should include the platform and database management system (DBMS) chosen for the project. Include any other information relevant to the database design decisions (e.g., Data Conversion Plan, Service Level Agreements (SLAs)). The Design Decisions section is written at a higher level than the subsequent Detailed Database Design section, and provides an understanding and rationale for the content in the Detailed Database Design section. If any of the information in this section is provided in the SDD, ICD(s), or other documents (e.g., Data Conversion Plan), they may be referenced within this section as appropriate.
5.1 Key Factors Influencing Design
Instructions: Describe key functional or non-functional requirements that influenced the design. If all such decisions are explicit in the requirements, this section shall so state. Design decisions that respond to requirements designated as critical (e.g., those for performance, availability, security, or privacy) shall be placed in separate subparagraphs. If a design decision depends upon system states or modes, this dependency shall be indicated. If some or all of the design decisions are described in the documentation of a custom or commercial DBMS, or in the SDD, they may be referenced in this section. Design conventions needed to understand the design shall also be presented or referenced.
5.2 Functional Design Decisions
Instructions: Describe decisions about how the database will behave in meeting its requirements from a user’s point of view (i.e., functionality of the database from an application perspective), ignoring internal implementation, and any other decisions affecting further design of the database. Include decisions regarding inputs the database will accept and outputs (displays, reports, messages, responses, etc.) it will need to support, including interfaces with other systems. Describe the general types of processing (sequential versus random for inserts, updates, deletes and queries) required both for data entering the database, and data most frequently accessed. If any of this information is provided in ICD(s) or other documents, they may be referenced. Describe selected equations/algorithms/rules, disposition, and handling of un-allowed inputs. Also include decisions on how databases/data files will appear to the user.
5.3 Database Management System Decisions
Instructions: Describe design decisions regarding the DBMS intended for the initial implementation. Provide the name and version/release of the DBMS, the reason for selection, and the type of flexibility built into the database for adapting to changing requirements.
5.4 Security and Privacy Design Decisions
Instructions: Describe design decisions on the levels and types of security and privacy to be offered by the database. General descriptions of classifications of users and their general access rights should be included.
5.5 Performance and Maintenance Design Decisions
Instructions: Describe how performance and availability requirements will be met. Examples include:
·
Describe design decisions on database distribution (such as client/server), master database file updates and maintenance, including maintaining consistency, establishing/ reestablishing and maintaining synchronization, enforcing integrity and business rules.
· Describe design decisions to address concurrence issues (e.g., how the data are partitioned or distributed to support multiple applications or competing update functions, if applicable).
· Describe design decisions to support Service Level Agreements (SLAs) for key functions supported by the database.
· Describe design decisions on backup and restoration including data and process distribution strategies, permissible actions during backup and restoration, and special considerations for new or non-standard technologies such as video and sound. Describe the impact this maintenance will have on availability.
· Describe design decisions on data reorganization (i.e., repacking, sorting, table and index maintenance), synchronization, and consistency, including automated disk management and space reclamation considerations, optimizing strategies and considerations, storage and size considerations (e.g., future expansion), and population of the database and capture of legacy data. Describe the impact this maintenance will have on availability.
· Describe design decisions to support purging and/or archiving of data to ensure performance and storage objectives are met. Describe the impact this maintenance will have on availability. Describe any needs to recall archived data back into the database.
6.
Statement of Work
Instructions: The statement of work should specify the mission/goal and objectives for the design. Include the SOW from part 1 of your project here.
7.
Requirements Analysis
Instructions: The requirements analysis should identify the system and user requirements for the system design. Include part 2 of your project here.
8.
Detailed Database Design
Instructions: Describe the design of all DBMS files associated with the system, and any non-DBMS files pertinent to the database design. The headings and sub-headings in this section should be structured according to the information to be presented, and may include discussions about or references to the following:
· Logical Data Model (LDM) and Entity Relationship Diagram (ERD).
·
Physical Data Model (PDM).
· A comprehensive Data Dictionary showing data stores, data element name, type, length, source, constraints, validation rules, maintenance (create, read, update, delete (CRUD) capability), audit and data masking requirements, expected data volumes, life expectancy of the data, information life-cycle management strategy or at least an archiving strategy, outputs, aliases, and description.
· Indexes that will be required for the data objects.
· Planned implementation factors (e.g., distribution and synchronization) that impact the design.
The detailed database design information can be included as an appendix, which would be referenced here. If any of the information in this section is provided in the SDD, ICD(s), or other documents, they may be referenced.
8.1 Data Software Objects and Resultant Data Structures
Instructions: For each functional data object, specify the data structure(s) which will be used to store and process the data. Describe any data structures that are a major part of the system, including major data structures that are passed between components. List all database objects including stored procedures, functions and function parameters. For functions, give function input and output names in the description. Refer as appropriate to the decomposition diagrams. Provide the detailed description of any non-DBMS files (e.g., property files) that are required for DBMS functioning or maintenance and are not already addressed in the SDD. Include a narrative description of the usage of each file that identifies if the file is used for input, output, or both, and if the file is a temporary file. Also provide an indication of which modules read and write the file (refer to the Data Dictionary). As appropriate, include file structure information.
8.2 Database Management System Files
Instructions: Provide an appropriate level of detailed design of the DBMS files, based on the DBMS chosen. Describe file structures and their locations. Explain how data may be structured in the selected DBMS, if applicable. For networks, detail the specific distribution of data. Note any changes to the LDM, which occur because of software or hardware requirements or to support performance objectives. Include the following information, as appropriate (refer to the Data Dictionary):
· Physical description of the DBMS schemas, sub-schemas, records, sets, tables, storage page sizes, etc. A PDM ERD should be included in an appendix.
· Objects created to support access methods (e.g., indexed, via set, sequential, random access, sorted pointer array, etc.)
· Distribution, partitioning, or other compartmentalization of the data to support design.
· Estimate of the DBMS file size or volume of data within the file, and data pages, including overhead resulting from access methods and free space.
· Definition of the update frequency of the database tables, views, files, areas, records, sets, and data pages. Also provide an estimate of the number of transactions, if the database is an online transaction-based system.
9.
Database Administration and Monitoring
Instructions: Within the following sub-sections, describe the requirements and strategies to maintain the database operationally considering the following:
· Required availability and requirements for standby sites of the data stores, both DBMS and non-DBMS to satisfy continuity of operations and meet required Service Level Agreements (SLAs).
· Any database specific application and user support scenarios that are not documented in the SDD.
· Any monitoring and performance goals/requirements, and how the DDD supports them.
· Required maintenance of the data stores to maintain acceptable performance.
· Backup and recovery strategies needed to implement the DDD.
· Any security and/or privacy considerations.
9.1 Roles and Responsibilities
Instructions: Identify the organizations and personnel responsible for the following database administrative functions: database administrator, system administrator, and security administrator. Describe specific administration skill requirements applicable to the database.
9.2 System Information
Instructions: Document the DBMS configuration, hardware configuration, database software utilities, and any support software used. If any of these software elements or hardware configurations are not CMS-standard architecture, indicate the date these items were approved or a waiver was granted.
9.2.1 Database Management System Configuration
Instructions: Identify the vendor, version or release date and targeted hardware for the DBMS chosen for the initial implementation of the database. Describe any restrictions on the initialization and use of the DBMS to support any intended distributed processing. Identify the minimum hardware configurations for the environment on which the database will reside. Describe the storage device and storage requirements. Provide sizing formulas for determining the storage required to support the database content and associated software. Estimate the internal and peripheral storage requirements. Identify multiple storage requirements for distributed processing.
9.2.2 Database Support Software
Instructions: List and reference the documentation of any DBMS utility software available to support the use or maintenance of the database. Describe all support software, including the operating system, directly related to the database, including name, version, function, and major operating characteristics. Cite documentation by title, number, and appropriate sections. Examples of such software include database management systems, query languages, report writers, storage allocation software, database-loading software programs, file processing programs, and data cleaning software.
9.2.3 Security and Privacy
Instructions: Describe the use and management of integrity and access controls that apply to all database components such as schema, sub-schema, partitions or physical files, records or tables, sets or relations, and data elements. Describe any tools or sub-schemas that will support security and privacy requirements.
9.3 Performance Monitoring and Database Efficiency
Instructions: Provide appropriate detailed subparagraphs that relate to the section named Performance and Maintenance Design Decisions. Describe what parties will be responsible for monitoring performance (to include space utilization, system resource consumption, and query performance metrics), along with tools that will help provide this monitoring. If interfaces with other systems impact maintenance, provide a description of those interfaces with other application software including those of other operational capabilities and from other organizations. For each interface, specify the information described in the following sub-sections.
9.3.1 Operational Implications
Instructions: Describe operational implications of data transfer, refresh and update scenarios and expected windows, including security considerations. If any of these are documented in the SDD or the ICD, they can be referenced here.
9.3.2 Data Transfer Requirements
Instructions: Describe data transfer requirements to and from the software, including data content, format, sequence, volume/frequency and any conversion issues. If any of these are documented in the SDD or the ICD, they can be referenced here.
9.3.3 Data Formats
Instructions: Describe formats of data for both the sending and receiving systems, including the data item names, codes, or abbreviations that are to be interchanged, as well as any units of measure/conversion issues. If any of these are documented in the SDD or the ICD, they can be referenced here.
9.4 Backup and Recovery
Instructions: Describe required strategies and scheduling for periodic backups of the data. If certain objects have differing requirements, provide a breakdown by object. Describe the methodology for reestablishment or recreation of the necessary data schema and system support files.
Appendix A: Suggested Appendices
Suggested appendices include, but are not limited to the following:
· PDM – provide the Physical Data Model prepared to support the project.
· PDM ERD – provide the Entity Relationship Diagram for the PDM.
· CRUD Matrix – provide CRUD Matrix (Create, Read, Update, Delete) indicating how the data will be maintained and accessed.
Appendix B: Acronyms
Instructions: Provide a list of acronyms and associated literal translations used within the document. List the acronyms in alphabetical order using a tabular format as depicted below.
Table 2 – Acronyms
Acronym
Literal Translation
Appendix C: Glossary
Instructions: Provide clear and concise definitions for terms used in this document that may be unfamiliar to readers of the document. Terms are to be listed in alphabetical order.
Table 3 – Glossary
Term
Acronym
Definition
Appendix D: Additional Appendices
Instructions: Utilize additional appendices to facilitate ease of use and maintenance of the document.
>Sheet _ISBN
_LENGTH
1 7
/20 1 Clark Drive
801
1 777 6
/20 – 4
6 5th Avenue, New York, NY
1 BOOK 5 9
0
1 1 th Street Library
4 E 125th St, New York, NY
New York Public Library 1 Christian Walker 96 Clark Drive Hicksvile NY 1 01 1 16777216 12 Dec/31/2019 New York Public Library 476 5th Avenue, New York, NY 1 Way of Kings Fantasy Tor Books BOOK 978076 6 79 1,280 2 2 /2012
E 125th St, New York, NY
101 New York Public Library 1 Christian Walker 96 Clark Drive Hicksvile NY 11801 1 16777216 1234 Dec/31/2019 New York Public Library 212-555-1234 476 5th Avenue, New York, NY 3 DVD 1 E th St, New York, NY
New York Public Library /2017
1 Christian Walker 96 Clark Drive Hicksvile NY 11801 1 16777216 1234 Dec/31/2019 New York Public Library 212-555-1234 476 5th Avenue, New York, NY 8 DVD 20 3 Grand Central Library 102 New York Public Library Apr/03/2017 Mar/28/2017 4 7 Circle Ave
2 5 2
0
New York Public Library 212-555-1234 476 5th Avenue, New York, NY 1 Way of Kings Fantasy Tor Books Aug/31/2010 BOOK 9780765365279 1,280 1 1 Feb/01/2011 125th Street Library 212-555-2345 101 New York Public Library 4 Emile Cross 387 Circle Ave Vincentown NJ 08088 2 8192 New York Public Library 212-555-1234 476 5th Avenue, New York, NY 2 Fantasy Tor Books BOOK 3 1 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library 2 3 60
/2020
1 Way of Kings Fantasy Tor Books Aug/31/2010 BOOK 9780765365279 1,280 21 1 201 Baltimore County Library 2 Deena Pilgrim 838 Orange Street Frederick MD 21701 3 10485760 8888 Baltimore County Library 443-555-3456 320 York Road, Towson, MD 1 Way of Kings Fantasy Tor Books Aug/31/2010 BOOK 9780765365279 1,280 22 2 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library 2 Deena Pilgrim 838 Orange Street Frederick MD 21701 3 10485760 8888 Feb/29/2020 Baltimore County Library 443-555-3456 320 York Road, Towson, MD 7 Fantasy BOOK 4079
29 1 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library 2 Deena Pilgrim 838 Orange Street Frederick MD 21701 3 10485760 8888 Feb/29/2020 Baltimore County Library 443-555-3456 320 York Road, Towson, MD 8 The Social Network Drama Columbia Pictures Oct/01/2010 DVD 2:01 1 202 Baltimore County Library 3 MD 4 Baltimore County Library 443-555-3456 320 York Road, Towson, MD 8 The Social Network Drama Columbia Pictures Oct/01/2010 DVD 2:01 42 1 Sep/15/2014 Woodlawn Branch 443-555-5678 1811 Woodlawn Dr, Woodlawn, MD 202 Baltimore County Library DVD 1 Woodlawn Branch 443-555-5678 1811 Woodlawn Dr, Woodlawn, MD 202 Baltimore County Library DVD 40 1 Woodlawn Branch 443-555-5678 1811 Woodlawn Dr, Woodlawn, MD 202 Baltimore County Library 5 NY 6 5 La La Land Musical Summit Entertainment Dec/09/2016 DVD 2:08 1 240-684-2020 1616 McCormick Dr, Largo, MD UMUC Library 5 Johnny Royalle 9948 Campfire Drive East Elmhurst NY 11369 6 32768256 8008 Mar/11/2020 UMUC Library 240-684-2020 1616 McCormick Dr, Largo, MD 3 Inception Science Fiction/Thriller Warner Bros Jul/08/2010 DVD 2:28 45 1 UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library 5 Johnny Royalle 9948 Campfire Drive East Elmhurst NY 11369 6 32768256 8008 Mar/11/2020 UMUC Library 240-684-2020 1616 McCormick Dr, Largo, MD 5 La La Land Musical Summit Entertainment Dec/09/2016 DVD 2:08 51 1 Jul/11/2017 UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library 4 Emile Cross 387 Circle Ave Vincentown NJ 08088 7 8192 UMUC Library 240-684-2020 1616 McCormick Dr, Largo, MD 5 La La Land Musical Summit Entertainment Dec/09/2016 DVD 2:08 51 1 Jul/11/2017 UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library 4 Emile Cross 387 Circle Ave Vincentown NJ 08088 7 16384512 8192 Feb/15/2020 UMUC Library 240-684-2020 1616 McCormick Dr, Largo, MD 8 The Social Network Drama Columbia Pictures Oct/01/2010 DVD 2:01 54 1 UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library 4 Emile Cross 387 Circle Ave Vincentown NJ 08088 2 33554432 8192 Jul/04/2020 New York Public Library 212-555-1234 476 5th Avenue, New York, NY 2 Words of Radiance Fantasy Tor Books Mar/04/2014 BOOK 9780765365286 1,328 3 1 Mar/04/2014 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library Oct/22/2017 4 Emile Cross 387 Circle Ave Vincentown NJ 08088 2 33554432 8192 Jul/04/2020 New York Public Library 212-555-1234 476 5th Avenue, New York, NY 2 Words of Radiance Fantasy Tor Books Mar/04/2014 BOOK 9780765365286 1,328 4 2 Mar/04/2014 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library MD 5 UMUC Library 240-684-2020 1616 McCormick Dr, Largo, MD Woodlawn Branch 443-555-5678 1811 Woodlawn Dr, Woodlawn, MD 202 Baltimore County Library UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library UMUC Library Woodlawn Branch 443-555-5678 1811 Woodlawn Dr, Woodlawn, MD 202 Baltimore County Library UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library McKeldin Library 301-405-9046 UMD, College Park, MD 302 UMUC Library Woodlawn Branch 443-555-5678 1811 Woodlawn Dr, Woodlawn, MD 202 Baltimore County Library 3 Sep/21/2015 Woodlawn Branch 443-555-5678 1811 Woodlawn Dr, Woodlawn, MD 202 Baltimore County Library UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library BOOK 5 1 Feb/01/2011 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library 1 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library Woodlawn Branch 443-555-5678 1811 Woodlawn Dr, Woodlawn, MD 202 Baltimore County Library 2 Woodlawn Branch 443-555-5678 1811 Woodlawn Dr, Woodlawn, MD 202 Baltimore County Library 1 UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library 2 UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library McKeldin Library 301-405-9046 UMD, College Park, MD 302 UMUC Library Grand Central Library 212-555-3456 135 E 46th St, New York, NY 102 New York Public Library Grand Central Library 212-555-3456 135 E 46th St, New York, NY 102 New York Public Library 722 8 1 Feb/01/2011 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library 1 McKeldin Library 301-405-9046 UMD, College Park, MD 302 UMUC Library 1 Jan/14/2017 Grand Central Library 212-555-3456 135 E 46th St, New York, NY 102 New York Public Library Grand Central Library 212-555-3456 135 E 46th St, New York, NY 102 New York Public Library 1. What are some of the major issues with the current file based storage model? 2. Are there data anomalies with the current solution? Can you provide specific examples of INSERT/UPDATE/DELETE anomaly? 3. If you design your database strictly based on the current model (meaning one table to store all information), would it be considered as normalized? Would it be in 1NF, 2NF, and 3NF? 4. If not, describe and illustrate the process of normalizing it to 3NF. Identify functional dependencies and create dependency diagram before each conversion. 5. Show the final table structure after normalization and make sure it is in 3NF. 6. Identify entities and attributes. List entity name and attribute names for each entity. 7. Identify relationships among entities. List relationship type in terms of cardinality and specify business rules (e.g. 1:M between Library and Branch: a library has one or many branches; a branch belongs to one and only one library). 8. For each entity, identify primary key and foreign key if applicable. If you use surrogate key for PK, also specify business unique key (natural key). For FK, also specify parent entity and the matching attribute in parent entity. 9. Create ERD using crow’s foot notation using ER Assistant or Visio. The ERD should incorporate all items mentioned in 2.1, 2.2, and 2.3 (NOTE: 2.1, 2.2, and 2.3 still need to be answered separately in narrative format). 10. Write SQL DDL statements to create tables in Oracle to implement all entities, attributes with the correct data type and data size, primary keys, foreign keys, and constraints such as NOT NULL. 11. Create indexes on all primary key, foreign key, and business key columns. 12. Write SQL DML statements to insert all data shown in the sample spreadsheet into the new database. 13. Write SQL queries against each table so that to display number of records in each table. 14. Write a minimum of 10 queries to query the database. 15. Write SQL statement to create a database view so that a report can be generated by querying the view to create the same set of data as shown in the original spreadsheet. Ideally the view is created by querying base tables directly. However, it is acceptable if it is based on other views but with only one nested level (the final view is against other intermediate level view(s), and each intermediate level view is a query against base tables directly).
2
1
TRANSACTION_UNIQUE_IDENTIFIER
CHECKOUT_DATE
DUE_DATE
RETURNED_DATE
CUSTOMER_UNIQUE_IDENTIFIER
CUSTOMER_FIRSTNAME
CUSTOMER_LASTNAME
CUSTOMER_STREET
CUSTOMER_CITY
CUSTOMER_STATE
CUSTOMER_ZIP
LIBRARY_CARD_UNIQUE_IDENTIFER
LIBRARY_CARD_NUMER
CARD_PIN
CARD_EXPIRATION_DATE
CARD_ISSUE_LIBRARY
LIBRARY_CONTACT_PHONE
LIBRARY_ADDRESS
CATALOG_ITEM_UNIQUE_IDENTIFIER
TITLE
DESCRIPTION
PUBLISHER
RELEASE_DATE
TYPE
BOOK
BOOK_PAGES
DVD
BRANCH_ITEM_UNIQUE_IDENTIFIER
BRANCH_ITEM_COPY_NUMBER
BRANCH_ITEM_PURCHASE_DATE
BRANCH_NAME
BRANCH_PHONE
BRANCH_ADDRESS
BRANCH_UNIQUE_IDENTIFIER
BRANCH_LIBRARY_SYSTEM
1
Feb/02/
20
7
Mar/02/
201
Feb/2
8
17
Christian
Walker
9
6
Hicksvile
NY
11
16
21
12
3
4
Dec/
31
19
New York Public Library
212-
5
55
1
23
47
Way of Kings
Fantasy
Tor Books
Aug/31/20
10
9780765
36
27
1,
28
Feb/01/2011
1
25
212-555-23
45
22
101
2 Feb/28/2017
Mar/28/2017
Apr/01/2017
18
34
212-555-1234
Aug/31/2010
53
52
Mar/
15
125th Street Library
212-555-2345
2
24
3 Apr/01/2017
May/01/2017
Apr/03/2017
Inception
Science Fiction/Thriller
Warner Bros
Jul/08/2010
2:28
13
Jul/08/2011
Grand Central Library
212-555-34
56
1
35
46
102
4 Apr/03/2017
May/03/2017
Apr/
30
The Social Network
Drama
Columbia Pictures
Oct/01/2010
2:01
Feb/23/2013
212-555-3456
135 E 46th St, New York, NY
5
Mar/03/2017
Emile
Cross
38
Vincentown
NJ
08088
33
54
43
8192
Jul/04/
202
224 E 125th St, New York, NY
6
Dec/12/2017
Jan/12/2018
3355
44
32
Jul/04/2020
Words of Radiance
Mar/04/20
14
9780765365286
1,328
Mar/04/2014
7 Dec/12/2017 Jan/12/2018 4 Emile Cross 387 Circle Ave Vincentown NJ 08088 2 33554432 8192 Jul/04/2020 New York Public Library 212-555-1234 476 5th Avenue, New York, NY 2 Words of Radiance Fantasy Tor Books Mar/04/2014 BOOK 9780765365286 1,328 4 2 Mar/04/2014 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library
8
Jul/14/2017
Aug/14/2017
Aug/20/2017
Deena
Pilgrim
838 Orange Street
Frederick
MD
21701
10
48
57
8888
Feb/
29
Baltimore County Library
443-555-3456
320 York Road, Towson, MD
Jun/14/2017
Essex Branch
443-555-4567
1100 Eastern Blvd, Essex, MD
9 Aug/20/2017
Sep/20/2017
Sep/19/2017
Feb/29/2020
10 Sep/19/2017
Oct/19/2017
Sep/21/2017
The Name of the Wind
DAW Books
Mar/27/2007
9780756
40
722
11 Sep/21/2017
Oct/21/2017
42
Sep/15/2014
Woodlawn Branch
443-555-5678
1811 Woodlawn Dr, Woodlawn, MD
12
May/12/2017
Jun/12/2017
May/31/2017
Calista
Secor
9330 El Dorado Lane
Temple Hills
20748
20971520
0911
May/17/2021
13 May/12/2017 Jun/12/2017 May/31/2017 3 Calista Secor 9330 El Dorado Lane Temple Hills MD 20748 4 20971520 0911 May/17/2021 Baltimore County Library 443-555-3456 320 York Road, Towson, MD 6
Moonrise Kingdom
Drama Comedy
Focus Features
May/25/2012
1:34
41
May/15/2015
14 May/12/2017 Jun/12/2017 May/31/2017 3 Calista Secor 9330 El Dorado Lane Temple Hills MD 20748 4 20971520 0911 May/17/2021 Baltimore County Library 443-555-3456 320 York Road, Towson, MD 5
La La Land
Musical
Summit Entertainment
Dec/09/2016
2:08
Dec/12/2016
15
Nov/11/2017
Dec/11/2017
Dec/09/2017
Johnny
Royalle
9948 Campfire Drive
East Elmhurst
11369
32768256
8008
Mar/11/2020
UMUC Library
240-684-2020
1616 McCormick Dr, Largo, MD
51
Jul/11/2017
UMUC Library Largo
301
16 Dec/09/2017
Jan/09/2018
Sep/09/2012
17 Dec/12/2017 Jan/12/2018
Dec/20/2017
18 Jul/14/2017 Aug/14/2017
Jul/20/2017
16384512
Feb/15/2020
19
Jul/21/2017
Aug/21/2017
Jul/22/2017
Dec/17/2015
20
Oct/12/2017
Nov/12/2017
Oct/22/2017
21
Oct/10/2017
Nov/10/2017
6
Harley
Cohen
96 Vine Street
Bowie
20715
65536128
4711
Oct/09/2019
1 Way of Kings Fantasy Tor Books Aug/31/2010 BOOK 9780765365279 1,280 33 1
Mar/03/2011
1 Way of Kings Fantasy Tor Books Aug/31/2010 BOOK 9780765365279 1,280 43 1
Sep/11/2011
1 Way of Kings Fantasy Tor Books Aug/31/2010 BOOK 9780765365279 1,280 55 1
Mar/08/2016
McKeldin Library
301-405-9046
UMD, College Park, MD
302
2 Words of Radiance Fantasy Tor Books Mar/04/2014 BOOK 9780765365286 1,328 23 1 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library
2 Words of Radiance Fantasy Tor Books Mar/04/2014 BOOK 9780765365286 1,328 24 2 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library
2 Words of Radiance Fantasy Tor Books Mar/04/2014 BOOK 9780765365286 1,328 34 1
Aug/19/2014
2 Words of Radiance Fantasy Tor Books Mar/04/2014 BOOK 9780765365286 1,328 44 1
Jan/12/2015
2 Words of Radiance Fantasy Tor Books Mar/04/2014 BOOK 9780765365286 1,328 56 1
Jul/12/2016
3 Inception Science Fiction/Thriller Warner Bros Jul/08/2010 DVD 2:28 14 2 Jul/08/2011 Grand Central Library 212-555-3456 135 E 46th St, New York, NY 102 New York Public Library
3 Inception Science Fiction/Thriller Warner Bros Jul/08/2010 DVD 2:28 15 3 Jul/08/2011 Grand Central Library 212-555-3456 135 E 46th St, New York, NY 102 New York Public Library
3 Inception Science Fiction/Thriller Warner Bros Jul/08/2010 DVD 2:28 25 1 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library
3 Inception Science Fiction/Thriller Warner Bros Jul/08/2010 DVD 2:28 35 1 Aug/19/2014 Woodlawn Branch 443-555-5678 1811 Woodlawn Dr, Woodlawn, MD 202 Baltimore County Library
3 Inception Science Fiction/Thriller Warner Bros Jul/08/2010 DVD 2:28 36 2
Sep/21/2015
3 Inception Science Fiction/Thriller Warner Bros Jul/08/2010 DVD 2:28
37
3 Inception Science Fiction/Thriller Warner Bros Jul/08/2010 DVD 2:28 46 2 Sep/09/2012 UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library
3 Inception Science Fiction/Thriller Warner Bros Jul/08/2010 DVD 2:28 47 3
Jul/14/2014
3 Inception Science Fiction/Thriller Warner Bros Jul/08/2010 DVD 2:28 48 4
Oct/19/2016
4
Infinite Jest
Tragicomedy
Brown, Little, and Co.
Feb/01/1996
9780316066525
1,079
4 Infinite Jest Tragicomedy Brown, Little, and Co. Feb/01/1996 BOOK 9780316066525 1,079 6 2 Feb/01/2011 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library
4 Infinite Jest Tragicomedy Brown, Little, and Co. Feb/01/1996 BOOK 9780316066525 1,079 7 3
Oct/09/2015
4 Infinite Jest Tragicomedy Brown, Little, and Co. Feb/01/1996 BOOK 9780316066525 1,079
26
4 Infinite Jest Tragicomedy Brown, Little, and Co. Feb/01/1996 BOOK 9780316066525 1,079 38 1
Nov/25/2014
4 Infinite Jest Tragicomedy Brown, Little, and Co. Feb/01/1996 BOOK 9780316066525 1,079
39
Feb/23/2015
4 Infinite Jest Tragicomedy Brown, Little, and Co. Feb/01/1996 BOOK 9780316066525 1,079
49
Jan/20/2013
4 Infinite Jest Tragicomedy Brown, Little, and Co. Feb/01/1996 BOOK 9780316066525 1,079
50
Feb/05/2015
4 Infinite Jest Tragicomedy Brown, Little, and Co. Feb/01/1996 BOOK 9780316066525 1,079 57 1
Dec/01/2016
5 La La Land Musical Summit Entertainment Dec/09/2016 DVD 2:08 16 1
Mar/01/2017
5 La La Land Musical Summit Entertainment Dec/09/2016 DVD 2:08 27 1 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library
6 Moonrise Kingdom Drama Comedy Focus Features May/25/2012 DVD 1:34 17 1
Dec/12/2013
6 Moonrise Kingdom Drama Comedy Focus Features May/25/2012 DVD 1:34 28 1 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library
6 Moonrise Kingdom Drama Comedy Focus Features May/25/2012 DVD 1:34 52 1 Jul/11/2017 UMUC Library Largo 240-684-2020 1616 McCormick Dr, Largo, MD 301 UMUC Library
7 The Name of the Wind Fantasy DAW Books Mar/27/2007 BOOK
9780756404079
7 The Name of the Wind Fantasy DAW Books Mar/27/2007 BOOK 9780756404079 722 9 2
Apr/15/2013
7 The Name of the Wind Fantasy DAW Books Mar/27/2007 BOOK 9780756404079 722 10 3
Dec/20/2014
7 The Name of the Wind Fantasy DAW Books Mar/27/2007 BOOK 9780756404079 722 11 4 Dec/20/2014 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library
7 The Name of the Wind Fantasy DAW Books Mar/27/2007 BOOK 9780756404079 722 12 5 Dec/20/2014 125th Street Library 212-555-2345 224 E 125th St, New York, NY 101 New York Public Library
7 The Name of the Wind Fantasy DAW Books Mar/27/2007 BOOK 9780756404079 722 30 2 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library
7 The Name of the Wind Fantasy DAW Books Mar/27/2007 BOOK 9780756404079 722 31 3 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library
7 The Name of the Wind Fantasy DAW Books Mar/27/2007 BOOK 9780756404079 722 53 1
Apr/09/2016
7 The Name of the Wind Fantasy DAW Books Mar/27/2007 BOOK 9780756404079 722
58
Jan/14/2017
7 The Name of the Wind Fantasy DAW Books Mar/27/2007 BOOK 9780756404079 722
59
8 The Social Network Drama Columbia Pictures Oct/01/2010 DVD 2:01 18 1
Oct/01/2011
8 The Social Network Drama Columbia Pictures Oct/01/2010 DVD 2:01 19 2 Oct/01/2011 Grand Central Library 212-555-3456 135 E 46th St, New York, NY 102 New York Public Library
8 The Social Network Drama Columbia Pictures Oct/01/2010 DVD 2:01 32 1 Jun/14/2017 Essex Branch 443-555-4567 1100 Eastern Blvd, Essex, MD 201 Baltimore County Library