Jon Reed_ER2

docx

School

University of West Florida *

*We aren’t endorsed by this school

Course

5725

Subject

Computer Science

Date

Jul 3, 2024

Type

docx

Pages

Uploaded by JonnyRico

Checkpoint 2.1: Do exercises 1, 2, 3. 1. What does it mean to say a field has unique values? -A field or combination of fields that has a unique value is called a key. 2. Why is it desirable to have a key be unique? -You want it to be unique to distinguish it from other keys. 3. Why does a file have to be organized by a key field? -A file needs to be organized by a key to help with the searching time and when the user is searching the database for a certain record. If a file did not have a key, then the file could be out of order or mixed up somewhere causing more time for searching. Checkpoint 2.3: Do exercises 1, 2, 3, 4. 1. What are the three main data models we have discussed? -The Hierarchical database, the network model, and the relational model. 2. Which data model is mostly used today? Why? -The Relational model. The reason is it uses the SQL standard to access the data and does not suffer drawbacks as the hierarchical and network models do. 3. What are some of the disadvantages of the hierarchical data model? 1. Not all situations fall into the one-to-many, parent-child format. 2. The choice in which files are linked may have an impact (positive or negative) on performance and storage. 3. All the parent's and child records are done physically. So, if a file of the dependent was reorganized then all the pointers would have to be reset.

4. What are some of the disadvantages of the network data model? 1. All the records are maintained by only using pointers. Which can make the database very difficult. 2. The deletion and updating of any kind of records would require a large number of pointer adjustments.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

IMG_7072.png

image.jpg

TaxPrep Instructional Assignment 2.docx

L05 Check Your Understanding 1: [23FA] CAS 100A, Sec 02: Eff Speech (WC, Bedell).pdf

hw01Task.pdf

Screenshot 2023-12-12 at 9.28.45 AM.png

week 3 individual project deliverable.docx

hw.docx

Recommended textbooks for you

EBK JAVA PROGRAMMING

Computer Science

ISBN:9781337671385

Author:FARRELL

Publisher:CENGAGE LEARNING - CONSIGNMENT

Programming Logic & Design Comprehensive

Computer Science

ISBN:9781337669405

Author:FARRELL

Publisher:Cengage

Systems Architecture

Computer Science

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Cengage Learning

Microsoft Visual C#

Computer Science

ISBN:9781337102100

Author:Joyce, Farrell.

Publisher:Cengage Learning,

Enhanced Discovering Computers 2017 (Shelly Cashm...

Computer Science

ISBN:9781305657458

Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Publisher:Cengage Learning

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:9781337102124

Author:Diane Zak

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning