AMA University Answers
Login
Register
AMA OED
Courses
ITE
ITE-6100B
Fundamentals of Database System
52 answers
A computerized system that permits users to create and maintain a database.
database management system
Correct
A displayed schema is called Schema figure.
False
Correct
A process of producing a set of tables (relations) with a proper attribute.
Normalization
Correct
A single entity instance of one entity class is related to a multiple entity instance of another entity class
One-to-Many
Correct
A single entity instance of one entity class is related to a single entity instance of another entity class.
One-to-One
Correct
All possible column values
Domain
Correct
Attribute is a name for a set of similar things that you can list. Like objects, events, people.
False
Correct
Column header / field A
Attributes
Correct
Controlling Redundancy is used to improve the performance of queries.
True
Correct
Data abstraction is the data type, relationships and constraints that apply to the data.
False
Correct
Data Manipulation Language is use for manipulating data in a database.
True
Correct
Data model is a collection of concepts that is used to describe the structure of a database.
True
Correct
Database System automatically takes care of backup and recovery.
True
Correct
Describes how entities are related.
relationships
Correct
Each entity instance of one entity class is related to a multiple entity instance of another entity class; and vice versa.
Many-to-Many
Correct
Entities can be related indirectly by two (2) relationships.
Transitive Relationship
Correct
Facts that can be recorded and that have implicit meaning.
data
Correct
Indirect relationship causes functional dependency.
transitive dependency
Correct
Internal Level describes the physical storage structure of the database.
True
Correct
It is a collection of related data.
database
Correct
It is a question or an inquiry, sometimes loosely used for all types of interactions with databases
query
Correct
It is a stricter form of 2 nd and 3 rd normal form
Boyce Codd Normal Form (BC/NF)
Correct
It is between high-level and low-level data models.
implementation data models
Correct
It is the number of attributes in a relation.
Degree of Relation
Correct
It is the number of tuples in a relation.
Cardinality of relation
Correct
Its is one or more columns of a relation or table that is used to identify a record.
Key
Correct
Matching Type Common Data Types
Matching Type Common Data Types
Correct
Matching Type Relational database schema commonly defines:
Matching Type Relational database schema commonly defines:
Correct
Maximum Cardinality describes the maximum number of entity instances in the relationship.
True
Correct
Minimum Cardinality describes the minimum number of entity instances that must participate in a relationship
True
Correct
Multi-value dependency
4th Normal Form (4NF)
Correct
NO “repeating groups” (columns)
1st Normal Form (1NF)
Correct
NO Partial Dependency
2nd Normal Form (2NF)
Correct
No primary key can be null.
True
Correct
NO Transitive Dependency
3rd Normal Form (3NF)
Correct
Null means a value is unknown.
True
Correct
Null means zero
False
Correct
People whose jobs require access to the database for querying, updating, and generating reports
end users
Correct
Physical data models is a concept that shows how the data is stored on the computer.
True
Correct
Relational Model is a table with columns and rows.
True
Correct
Relationships can't have attributes.
False
Correct
Table definition
Schema of relation
Correct
The participation of an entity in the relationship is mandatory.
Mandatory
Correct
The participation of an entity in the relationship is optional.
Optional
Correct
The relational model (RM) was first described by Edgar F. Codd
True
Correct
The table is in a 1NF if It satisfies the definition of a relation.
True
Correct
The table is in a 2NF if there's NO Partial Dependency.
True
Correct
There’s no difference between the description of database and the database itself.
False
Correct
They are liable for identifying the data to be stored within the database and for selecting appropriate structures to represent and store this data
database designers
Correct
This relationship exists if they are independent or different to each other.
Multiple Relationship
Correct
We call the database and DBMS software together as a
database system
Correct
Who is responsible in administering the primary and secondary resource in the database?
database administrator
Correct
Search
All courses
ACTG
Cost Accounting and Control -
(101 answers)
Intermediate Accounting 3 -
(117 answers)
BAMM
Macroeconomics Theory and Practice -
(132 answers)
BIO
Biological Science -
(155 answers)
COMM
Introduction to Communication Media -
(23 answers)
COMP
Current Trends and Issues -
(453 answers)
CPE
Introduction to HDL -
(100 answers)
CS
2D/3D Digital Animation -
(108 answers)
Algorithms and Complexity -
(107 answers)
Animation Project -
(61 answers)
Application Life Cycle Management -
(272 answers)
Audio and Video Production (Digital Imaging) -
(370 answers)
Automata Theory and Formal Language -
(246 answers)
Computer Architecture and Organization -
(14 answers)
Discrete Mathematics -
(326 answers)
Discrete Structures 2 -
(106 answers)
Introduction to Machine Learning -
(163 answers)
Load Testing -
(189 answers)
Logic Design and Digital Computer Circuits -
(27 answers)
Mobile Application Development -
(60 answers)
Modeling and Simulation -
(90 answers)
Object Oriented Programming -
(155 answers)
Principles of Operating Systems and its Applications -
(189 answers)
Programming Languages with Compiler -
(40 answers)
Software Engineering 1 -
(316 answers)
Software Engineering 2 -
(186 answers)
Statistical Analysis with Software Application -
(174 answers)
Unified Functional Testing -
(107 answers)
ECE
Electronics 1: Electronic Devices and Circuits -
(169 answers)
Fundamentals of Mixed Signals and Sensors -
(98 answers)
ECON
Managerial Economics -
(5 answers)
EE
Electric Circuits Theory 2 -
(67 answers)
ENG
Computer Aided Drawing -
(114 answers)
Engineering Economincs -
(79 answers)
ENGL
Afro-Asian Literature -
(202 answers)
Philippine Literature -
(278 answers)
Purposive Communication 2 -
(240 answers)
Speech Communication 2 -
(152 answers)
ETHNS
Euthenics 1 -
(151 answers)
Euthenics 2 -
(239 answers)
FILI
Kritikal na Pagbasa, Pagsulat at Pagsasalita -
(558 answers)
Pagsasaling Pampanitikan -
(270 answers)
FLN
Foreign Language -
(278 answers)
GE
Art Appreciation -
(260 answers)
Environmental Science -
(269 answers)
Ethics -
(139 answers)
Life and Works of Jose Rizal -
(518 answers)
Living in the IT Era -
(135 answers)
Mathematics in the Modern World -
(111 answers)
Philippine Popular Culture -
(149 answers)
Purposive Communication 1 -
(59 answers)
Readings in Philippine History -
(214 answers)
Science, Technology and Society -
(358 answers)
The Contemporary World -
(226 answers)
Understanding the Self -
(204 answers)
GMAT
General Mathematics -
(8 answers)
IA
Accounting Information System -
(143 answers)
IT
Advanced Database Management Systems -
(139 answers)
Audio and Video Production -
(57 answers)
Cisco - Introduction to Packet Tracer -
(21 answers)
Data Communications and Networking 1 -
(271 answers)
Data Communications and Networking 2 -
(361 answers)
Data Communications and Networking 3 -
(247 answers)
Data Communications and Networking 4 -
(140 answers)
Database Management System 1 (Oracle) -
(144 answers)
Database Management System 2 (Oracle 10g Admin) -
(187 answers)
Information Assurance and Security 1 -
(405 answers)
Information Assurance and Security 2 -
(93 answers)
Integrative Programming and Technology 1 -
(109 answers)
Introduction to Human Computer Interaction -
(432 answers)
Introduction to Multimedia -
(366 answers)
IT Capstone Project 1 -
(82 answers)
Network Security -
(30 answers)
Project Management -
(258 answers)
Quantitative Methods -
(19 answers)
Screenwriting -
(102 answers)
System Administration and Maintenance -
(74 answers)
System Integration and Architecture 1 -
(160 answers)
Web Application Development 1 -
(218 answers)
Web Enhanced Animation Graphics -
(137 answers)
Web Systems Technologies -
(115 answers)
IT
Web Application Development 2 -
(63 answers)
ITE
Application Development and Emerging Technology -
(570 answers)
Cloud Computing and the Internet of Things -
(292 answers)
Computer Programming 1 -
(752 answers)
Computer Programming 2 -
(146 answers)
Data Structures and Algorithm Analysis -
(228 answers)
Fundamentals of Database System -
(52 answers)
Information Management -
(377 answers)
Introduction to Computing -
(144 answers)
Social and Professional Issues -
(436 answers)
Technopreneurship -
(177 answers)
MATH
Calculus 1 -
(164 answers)
Data Analysis -
(251 answers)
Differential Equation -
(50 answers)
Number Theory -
(268 answers)
Numerical Methods -
(256 answers)
MGT
Production Operations Management -
(151 answers)
Strategic Management -
(138 answers)
NSCI
Anatomy -
(58 answers)
Calculus-Based Physics 1 -
(222 answers)
Calculus-Based Physics 2 -
(258 answers)
NSTP
National Service Training Program 1 -
(352 answers)
National Service Training Program 2 -
(198 answers)
OFAD
Web Design -
(54 answers)
PHYED
Individual/Dual Sports -
(303 answers)
Physical Fitness -
(537 answers)
Rhythmic Activities -
(203 answers)
Team Sports -
(281 answers)
PSYC
Abnormal Psychology -
(14 answers)
Developmental Psychology -
(311 answers)
Introduction to Psychology -
(227 answers)
Physiological Psychology -
(98 answers)
RSCH
Accounting Research Methods -
(57 answers)
Inquiries, Investigations and Immersion -
(226 answers)
Practical Research 1 -
(249 answers)
TAX
Income Taxation -
(75 answers)