Entity Types and Instances Flashcard

Front

In a flight tracking database, the schema defines AIRCRAFT with attributes for Model and Capacity. On the runway, a specific Boeing 747 with the tail number N12345 is preparing for takeoff. Is the specific Boeing 747 (N12345) the Entity Type or the Entity Instance?

Back

Entity Instance

Front

What does the table name PATIENT represent in a hospital’s RDBMS when John Doe (SSN: 000-11-2222) is admitted?

Back

Entity Type

Front

A property management system tracks APARTMENT_UNIT. You are currently looking at the data for Unit 4B at The Palms Complex. Identify the Entity Instance in this scenario.

Back

Unit 4B at The Palms Complex

Front

Is "Introduction to SQL (Section 01)" the Entity Type or Instance?

Back

Entity Instance

Front

An IT asset manager tracks SERVER. In the server rack, the machine labeled SRV-DB-09 is currently overheating. Identify the Entity Type.

Back

SERVER

Front

Does the Red 2024 Ford F-150 represent the Entity Type or Instance?

Back

Entity Instance

Front

The HR software contains a profile for EMPLOYEE. Alice Smith, who was hired yesterday, has been assigned Employee ID #889. What is Alice Smith?

Back

Entity Instance

Front

Is BANK_ACCOUNT the Entity Type or Instance?

Back

Entity Type

Front

A shipping company tracks DELIVERY_TRUCK. Truck #55, driven by Marcus, is currently on Route 4. Identify the Entity Instance.

Back

Truck #55

Front

A clothing store’s inventory system lists PRODUCT_ITEM. A specific Navy Blue Wool Sweater (Size Large) is scanned at the register. Is PRODUCT_ITEM the Type or the Instance?

Back

Entity Type