ISDS 7301 Latest Update 2025-2026 Exam 70 Questions with 100% Verified Correct Answers Guaranteed A+
_, @, # are ? - CORRECT ANSWER: Identifiers
/* or */ and -- are used to what ? - CORRECT ANSWER: Ways to specify a comment
1NF = - CORRECT ANSWER: Eliminate Repeating Group, make seperate table for
each set of related attribute and give each table a primary key
2NF = - CORRECT ANSWER: Eliminate Redundant data, if an attribute depends on
only part of a multi-valued key, remove it to a separate table
3NF = - CORRECT ANSWER: Eliminate columns not dependent on Key; if attributes do not contribute to a description of the key, remove them to separate table
A composite attribute contains? - CORRECT ANSWER: other attributes that can be
divided into smaller parts
a multivalued attribute may have ? - CORRECT ANSWER: One or more values
a relationship exist when an entity refers to ? - CORRECT ANSWER: one or more other entities
A table is in (2NF) if ? - CORRECT ANSWER: It is in (1NF) and these is no nonkey column dependent on a partial primary key of that table
- / 2
A table is in (3NF) if ? - CORRECT ANSWER: it is in 2nf and there are no functional dependencies between nonkey columns
All relational tables are by definition in, and why? - CORRECT ANSWER: 1NF ( first normal form) , this is because the value of any column in a row must be atomic
an address is an example of a ___ attribute and why? - CORRECT ANSWER:
composite, is made up of multiple atomic attributes such as , city , zip, and street
An atomic value is always represented by ? - CORRECT ANSWER: a single value for a particular entity
Atomic means? - CORRECT ANSWER: single valued
Attributes of employee? - CORRECT ANSWER: emp_no, emp_fname, emp_lname
Attributes of project? - CORRECT ANSWER: Project_no, project_name, budget
Composite attributes are ? - CORRECT ANSWER: Assembled using other atomic
attributes
DDL contains what three generic statements? - CORRECT ANSWER: Create, alter and
drop
DML ? - CORRECT ANSWER: Emcompasses all operations that manipulate the data
Each entity has ? - CORRECT ANSWER: Attributes
- / 2