Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

BTM 382 > Data Models > Flashcards

Data Models Flashcards

1
Q

What is data modeling?

A

It is the creation of a specific data model for a determined problem domain

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a data model?

A

It is a simple representation of complex real-world data structures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a model?

A

It is an abstraction of a more complex real-world object or event

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Why is data modeling important?

A

Facilitates communication
Gives various views of the database
Organizes data for various users
Provides an abstraction for the creation of good a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is an entity?

A

It is a person, place, thing, or event about which data will be collected and stored

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is an attribute?

A

It is a characteristic of an entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a relationship?

A

It is the association among entities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a constraint?

A

It is a restriction placed on data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are business rules?

A

They are brief, precise, and unambiguous descriptions of a policy, procedure, or principle within a specific organization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the sources of business rules?

A

Company managers
Policy makers
Department managers
Written documentation
Direct interviews with end users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the reasons for identifying and documenting business rules?

A

Standardize company’s view of data
Facilitate communications tool between users and designers
Assist designers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are relationships?

A

They are bidirectional

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are entity name requirements?

A

Be descriptive of the objects in the business environment
Use terminology that is familiar to the users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are attribute names?

A

They are required to be descriptive of the data represented by the attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What does proper naming do?

A

Facilitates communication between parties
Promotes self-documentation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are hierarchical models?

A

They are developed to manage a large amount of data for complex manufacturing projects

17
Q

What are network models?

A

They are created to represent complex data relationships effectively

18
Q

What is a table?

A

It is a logical construct perceived to be a two-dimensional structure composed of intersecting rows (entities) and columns (attributes) that represents an entity set in the relational model

19
Q

What is a relational model?

A

It is a model based on a mathematical set theory and represents data as independent realtions

20
Q

What is a relational database management system?

A

Performs basic functions provided by the hierarchical and network DBMS systems
Makes the relational data model easier to understand and implement
Hides the complexities of the relational model from the user

21
Q

What is an SQL-based relational database application?

A

It is an end-user interface that allows end users to interact with the data
A collection of tables stored in the database
And an SQL engine that executes all queries

22
Q

What is an Entity Relationship Diagram (ERD)?

A

It is a graphic representation to model database components

23
Q

What is an entity instance or entity occurence?

A

It is the rows in the relational table

24
Q

What is connectivity?

A

It is a term used to label relationship types

25
Q

What is an object?

A

It is a structure that contains both data and its relationships with operations that are performed on it

26
Q

What is a class?

A

A collection of similar objects with shared structure and behaviour organized in a class hierarchy

27
Q

What is class hierarchy?

A

Resembles an upside-down tree in which each class has only one parent

28
Q

What is inheritance?

A

Object inherits methods and attributes of classes above it

29
Q

What is Unified Modeling Language (UML)?

A

Describes sets of diagrams and symbols to graphically model a system

30
Q

What is an Extended relational data model (ERDM)?

A

It is a model that includes object-oriented model’s best features in an inherently simpler relational database structural environment

31
Q

What is an Extensible Markup Language (XML)?

A

It is a metalanguage used to represent and manipulate data elements

32
Q

What are the goals of big data?

A

Find new and better ways to manage large amounts of web and sensor-generated data
Provide high performance at a reasonable cost

33
Q

What are the characteristics of Big Data?

A

Volume
Velocity
Variety

34
Q

What are the challenges of Big Data?

A

Volume doesn’t allow usage of conventional structures
Expensive
OLAP tools proved inconsistent dealing with unstructured data

35
Q

Name some of the new technologies created from Big Data

A

Hadoop
Hadoop Distributed File System (HDFS)
MapReduce
NoSQL

36
Q

What are NoSQL databases?

A

It is a new generation of database management systems that is not based on the traditional relational database model

BTM 382 (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions