Chapter 4 Types of Data Models – Database Design – 2nd Edition (2024)

Main Body

Adrienne Watt & Nelson Eng

High-level Conceptual Data Models

High-level conceptual data models provide concepts for presenting data in ways that are close to the way people perceive data. A typical example is the entity relationship model, which uses main concepts like entities, attributes and relationships. An entity represents a real-world object such as an employee or a project. Theentity has attributes thatrepresent properties such as an employee’s name, address and birthdate. A relationship represents an association among entities; for example, an employee works on many projects. Arelationship exists between the employee and each project.

Record-based Logical Data Models

Record-based logical data models provide concepts userscanunderstandbut are not too far from the way data is stored in the computer. Three well-known data models of this type are relational data models, network data models and hierarchical data models.

  • The relational model represents data as relations, ortables. For example, in the membership system at Science World, each membership has many members (see Figure 2.2 in Chapter 2). The membership identifier, expiry date and address information are fields in the membership. The members are individuals such as Mickey, Minnie, Mighty, Door, Tom, King, Man and Moose. Each record is said to be an instance of the membership table.
  • The network model represents data as record types. This model also represents a limited type of one to many relationship called a set type, as shown in Figure 4.1.
Chapter 4 Types of Data Models – Database Design – 2nd Edition (1)
  • The hierarchical model represents data as a hierarchical tree structure. Each branch of the hierarchy represents a number of related records. Figure 4.2 shows this schema in hierarchical model notation.
Chapter 4 Types of Data Models – Database Design – 2nd Edition (2)

Key Terms

hierarchical model: represents data as a hierarchical tree structure

instance: a record within a table

network model: represents data as record types

relation: another term for table

relational model: represents data as relations or tables

set type: a limited type of one to many relationship

Exercises

  1. What is a data model?
  2. What is a high-level conceptual data model?
  3. What is an entity? An attribute? A relationship?
  4. List and briefly describe the common record-based logical data models.

Attribution

This chapter ofDatabase Designis a derivative copy ofDatabase System ConceptsbyNguyen Kim Anhlicensed underCreative Commons Attribution License 3.0 license

The following material was written by Adrienne Watt:

  1. Key Terms
  2. Exercises
Chapter 4 Types of Data Models – Database Design – 2nd Edition (2024)
Top Articles
Homemade Waterproof Sunscreen - Natural & Safe DIY Recipe - greenbeautymama.com
Easiest Lotion Bar Recipe with Beeswax (Non Greasy)
Ucsf Ilab
Buff Streams .Io
Miramar Water Utility
Are Pharmacy Open On Sunday
Frank 26 Forum
Realidades 2 Capitulo 2B Answers
Craigslist Pinellas County Rentals
Nashville Tranny
Milk And Mocha Bear Gifs
Craigslist Rooms For Rent North County San Diego
‘Sound of Freedom’ Is Now Streaming: Here’s Where to Stream the Controversial Crime Thriller Online for Free
Courierpress Obit
Walmart Listings Near Me
Party City Enfield Photos
Exploring IranProud: A Gateway to Iranian Entertainment
SIM Cards, Phone Cards & SIM Cards, Cell Phones & Accessories
Ups Drop Off Newton Ks
Ekaterina Lisina Wiki
Thothub Alinity
80 For Brady Showtimes Near Brenden Theatres Kingman 4
Dragon Ball Devolution 2 Unblocked
Ixl.prentiss
Restored Republic December 1 2022
Lvaction Login
Publix Christmas Dinner 2022
Gwcc Salvage
The 10 Craigslist Guys You’ll Live With in DC
Helas Kitchen Menu
10 Best Laptops for FL Studio in 2023 | Technize
Credit Bureau Contact Information
Megan Bayne Has Made A Mega Mark Since Arriving In Stardom
Metalico Sharon Pa
Malibu Horror Story Showtimes Near Regal Atlantic Station
Today's Final Jeopardy Clue
6023445010
Lagniappemobile
Dc Networks Claimant Services
Craigslist Hawley Pa
Circuit Court Peoria Il
Meshuggah Bleed Tab
Top 10 websites to play unblocked games
Ultipro Fleet Farm
Portmanteau Structure Built With Cans
Carros Jeep Wrangler Tachira | MercadoLibre 📦
Basketball Stars Unblocked Games Premium
Craig List El Paso Tx
Chase Bank Time Hours
Dean Dome Seating Chart With Rows And Seat Numbers
Milly Bobby Brown Nsfw
Fitgirl Starfield
Latest Posts
Article information

Author: Horacio Brakus JD

Last Updated:

Views: 6282

Rating: 4 / 5 (51 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Horacio Brakus JD

Birthday: 1999-08-21

Address: Apt. 524 43384 Minnie Prairie, South Edda, MA 62804

Phone: +5931039998219

Job: Sales Strategist

Hobby: Sculling, Kitesurfing, Orienteering, Painting, Computer programming, Creative writing, Scuba diving

Introduction: My name is Horacio Brakus JD, I am a lively, splendid, jolly, vivacious, vast, cheerful, agreeable person who loves writing and wants to share my knowledge and understanding with you.