Expand the words in CASE.

Computer-aided software engineering

What is an organized collection of logically related data?

Database, pero mali daw (Tables baka?)

The internal schema is the underlying design and implementation of the database. True or false?

False, pero nakalagay sa mod true dapat

Help

Options

focusNode

Didn't know it?
click below

Knew it?
click below

Don't Know

Remaining cards (0)

Know

retry

shuffle

restart

0:00

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

Inf0m4n Midterms

(private) FA 1,2,3

Question	Answer
Expand the words in CASE.	Computer-aided software engineering
CASE tools are not a part of the database environment.	False
A metadata is a descriptions of the properties or characteristics of the data. True or false?	True
One problems of a database approach is compromised data integrity. True or false?	False
An SDLC approach to the database has a repeated implementation and maintenance of activities with a new prototype version. True or false?	False, Prototyping
What is an element of a database approach that is a noun form describing a person, place, object, event, or concept?	Entity
Given the choices, which among the following is a disadvantage of file processing wherein programmers must design their own formats?	Lengthy Development times
In program data dependency, each application program needs to include code for the metadata of each file. True or false?	True
A metadata is a data that characterizes the properties and context of user data.	True
What is a data model that has a more detailed view and matching data structure in the database or data warehouse?	Project data model
Converting to an operational system in RAD usually means database maintenance. True or false?	True
What is the kind of database technology that has started in the 1960s and has became a legacy system in the mid 1980s?	Flat files
The database activity of the logical design step in SDLC is the logical database design.	True
Operational programs, documentation and training materials are the deliverables of the maintenance step in SDLC. True or false?	False, Implementation
The purpose of Planning in SDLC is the preliminary understanding of what the system is. True or false?	True
Request for study is the deliverable in the planning step of SDLC. True or false?	True
The purpose of the implementation step in SDLC is the programming, testing, training, installation, and documenting the system. True or false?	True
The RAD type of development process define database during development of initial prototype.	True
Expand the words RAD.	Rapid Application Development
SDLC is a long development cycle.	True
These are the or characteristics of an entity or relationship type.	Attributes
What is the number of instances of one entity that can be associated with each instance of another entity?	Cardinality
Attributes that contains data that will change overtime is the best attribute for an identifier. True or false?	False
This cardinality of relationship shows entities on both sides of the relationship can have many related entities on the other side.	many to many
What is the relationship that links strong entities to weak entities?	Identifying relationship
A ternary relationship should be converted to an associative entity. True or false?	True
What is a type of attribute whose values can be calculated from related attribute value?	Derived
This cardinality of relationships is an entity in the relationship will have exactly one related entity.	one to one
An associative entity is like a relationship with an attribute, but it is also considered to be an entity in its own right. True or false?	True
In the entity Patient, Address is a simple attribute. (Lot no, Street Number, City, Country)	False
The biggest problem in data redundancy is changes in one file could cause inconsistencies. This problem compromises what?	Data integrity
What is a data model that has high-level entities and relationships for the organization?	Enterprise data model
Tables that represent entities and primary/foreign keys that reflect relationships make up a relational database. True or False?	True
The waste of space caused by having duplicate data is a challenge with database approaches. True or false?	False
What is an organized collection of logically related data?	Database, pero mali daw (Tables baka?)
Which among the following is an example of an unstructured data	Documents
A _____ is a software for managing the database.	Database Management System
A good business rule is declarative, precise, atomic, consistent, expressible, distinct, and business-oriented. True or false?	True
Analyzing database to ensure it meets application needs and fixing the errors of the database is in what process of RAD?	Database Maintenance
The typical number of users using the personal type of database is only one.	True
External schema is the subset of the conceptual schema. True or false?	True
Implementation and maintenance activities are done repetitively with new prototype versions. True or false?	True
The internal schema is the underlying design and implementation of the database. True or false?	False, pero nakalagay sa mod true dapat
Which among the following became a legacy system during the 1990s?	Network
E-R models are found in the conceptual schema of the database. True or false?	True
What is a type of attribute that may take on more than one value for a given entity instance?	Multivalued
In the diagram 1, what is the cardinality of the relationship between entities? (PatiendId pointing to PatientId sa ibang entity)	one to many
In the attributes of the entity PatientHistory, DoctorId is a simple attribute.	True
Relationship degrees specify how many of each entity type is allowed. True or false?	False
All relationships for the associative entity should be many. True or false?	True
In defining attributes, it is important to make it clear what it is and is not included in the attribute’s value. True or false?	True
In the attributes of the entity PatientHistory, CheckinDate is a simple attribute.	False
What is an attribute or combination of attributes that uniquely identifies individual instances of an entity type?	Identifier
In the entity Patient, PatientName is a composite attribute.	True
What is a component of a database environment that is the storehouse of the data?	Database
One of the costs in database approach is hiring new and specialized personnel to manage the DBMS. True or false?	True
Inconsistencies are always found in a database approach. True or false?	False
Data types, field sizes, allowable values, and data context are included in metadata. True or false?	True
Non-standard file formats exists in program data dependency. True or false?	True
In program data dependency, there is coordination and central control of data. True or false?	False
One of the problems with data redundancy is the waste of space because of duplicate data. True or false?	True
Enforcing of standards is applied in file processing approach. True or false?	False
What is the step in SDLC that its purpose is a thorough requirements analysis and structuring the system?	Analysis
What is the database application that integrates all enterprise functions (manufacturing, finance, sales, marketing, inventory, accounting, human resources)?	Enterprise Resource Planning
Projects are closed at the end of the maintenance. True or false?	False, end of implementation
Planned undertaking of related activities to reach an objective that has a beginning and an end	Project
Initiated and planned in planning stage of SDLC	Project
Executed during analysis, design, and implementation	Project
The deliverable of the logical design of SDLC is the detailed design specification. True or false?	True
Projects are initiated and planned during the maintenance stage of SDLC. True or false?	False, Planning
The associative entity may participate in other relationships other than the entities of the associated relationship. True or false?	True
Entities of two different types related to each other is a binary degree of relationship. True or false?	True
A strong entity does not have an identifier. True or false?	False
Entities of three different types related to each other is a ternary degree of relationship. True or false?	True
Which among the attribute of both entities is mutivalued?	Symptom
This cardinality of relationship shows an entity on one side of the relationship which can have many related entities, but an entity on the other side will have a maximum of one related entity. What cardinality is this?	one to many
What do you call the people who use the applications and the database	End users
Different system/programs have separate copies of the same data in database approach. True or false?	False
What is a repository of shared data that is stored in a standardized, convenient form that is managed by a controlling agent?	Database
The external schema shows that different people have different views of the database. True or false?	True
Periodic audits is the deliverable of the maintenance step in SDLC. True or false?	True
A functional system specification is the deliverable of the analysis step of SDCL. True or false?	True
A data warehouse is an integrated decision support system derived from various operational databases. True or false?	True
Operational programs, documentation and training materials are the deliverables of the implementation step in SDLC. True or false?	True
Develop the technology and organizational specifications is the purpose of the Logical Design in SDLC. True or false?	False, Physical Design
SDLC is a time consuming development cycle but comprehensive. True or false?	True
A dependent entity is another name for weak entity. True or false?	True
The associative entity preferably has a unique identifier, and should also have other attributes. True or false?	True
In the attributes of the entity PatientHistory, DoctorId is a composite attribute.	False
The degree of the relationship is the number of entity types that participate in a relationship. True or false?	True
Entities of three different types related to each other is a binary degree of relationship. True or false?	False, Ternary
A required attribute must have a value for every entity. True or false?	True
Supertype entities inherit values of all attributes of the subtypes.	False
In diagram 4, What is the completeness constraint of the diagram?	Partial Specialization (Single Line)
What is a simple attribute with alternative values to indicate the possible subtypes?	Disjoint
In diagram 4 ,the attribute Location of the Buildings entity will be inherited only by the Commercial_Building entity.	False
If supertype A has three subtypes, which are subtypes 1, 2 and 3, and subtypes 1 and 2 have a relationship, this means that subtype 3 has also a relationship with subtypes 1 and 2.	False?
True or false. If supertype A has a relationship with supertype B, the subtypes under supertype A should not have a relationship with supertype B.	False
It is a generic entity type that has a relationship with one or more subtypes.	Supertype
In diagram 4, the attributes of the entity Buildings are inherited by all its subtypes.	True
True or false. The overlap rule in disjointness constraints is where an instance of the supertype can be only one of the subtypes.	False, Disjoint
True or false. The total specialization rule in completeness constraints is represented by a single line	False, Double line
When a regular entity is mapped into a relation with a multivalued attribute, that attribute becomes a separate relation with foreign key taken from the superior entity.	True
True or false. Every attribute value of a relation must be atomic.	True
True or false. Key fields can only be composite keys or use more than one field for keys.	False?
True or false. Relationships is another name for tables in database.	False, Relations?
True or false. Rows of the table in a database correspond with entity instances and with many-to-many relationship instances.	True
A primary key of a table guarantees that all rows are unique.	True
When mapping a supertype/subtype relationships into relations, supertype attributes go into supertype relation, including its identifier and subtype discirminator.	True
When can a table be qualified as a relation?	A table is qualified to be a relation if it has a unique name.
If you have an entity that Student, that has the following attributes: {IdNumber, Name, Address, Birthday}, which among the attributes should be a primary key?	IDNumber
Course In the course table, if we are going to insert a new student to take the course of Java, they is no insertion anomaly.	False
A 3NF is a 2NF plus no transitive dependencies.	True
Course Table The course table is in 1NF. (Separate c1,c2, at c3)	True
Course In the course table, if we are going to insert a new student to take the course of Java, they is an insertion anomaly because there is duplication of data for the course code, course name and teacher.	True?
A 1NF table is a table with composite attributes and every attribute is atomic.	False
A transitive dependency is when a non-key is functionally dependent on another non-key.	True
When there is an existing multivalued attribute in a 1NF table, it means its relation.	False
Using figure 4.2, convert this table to 1NF. Choose the correct relation below.	Yung nilagay lahat ng composite attributes (May CustomerLName)
following is the equivalent relation of the Chemical entity	chemicalId Name Formula
Using figure 4.1, map the supplier entity to a relation. Which among the following is the equivalent relation of the supplier entity	Supplier Name Contact
True or false. The partial specialization rule in completeness constraints is represented by a single line	True
Given the entities in Diagram 2, if generalization is used, what will be the supertype?	Access ID, Manufacturer, Height, Weight, Color
What is the process of defining a more general entity type from a set of more specialized entity types?	Bottom up
True or false. The disjoint rule in disjointness constraints is an instance of the supertype can be only one of the subtypes.	True
Using diagram 3, which among the following is the supertype?	Worker
True or false. A set of one or more entity types and associated relationships grouped into a single abstract entity type is called a combined entity.	False, Entity Cluster
In diagram 4, what do you call the Building entity?	Supertype
True or false. A completeness constraint identifies whether an instance of a supertype must also be a member of at least one subtype.	True
True or false. An instance of a subtype cannot be instance of the supertype.	False
True or false. The order of the rows in the database table must be irrelevant.	True
True or false. The order of the columns in the database table must be irrelevant.	True
True or false. A relation in relational database is the same as the word relationship in an E-R model.	False
All first normal form tables are relations.	True
True or false. A primary key of a table guarantees that all columns are unique.	False, all rows
When mapping binary relationships of EER diagrams, if the relationship is one to many, the primary key on the one side becomes a foreign key on the many side.	True
Keys in a relation have two purposes, which are the primary key and foreign key.	True
A table in a database is consists of rows and columns.	True
What is wrong with the relation below if the primary key is EmpId	The primary key should be unique, therefore there is something wrong with the values of the primary key.
A 1NF has no partial dependencies.	False, 2nf
A 2NF has no partial dependencies.	True
A transitive dependency is when a key is functionally dependent on non-key.	False, non-key
Anomalies found in relations are good because it helps build the relation.	False
An insertion anomaly is when adding a row in a table forces users to create duplicate data.	True
A deletion anomaly is when revising data in a row forces changes to other rows because of duplication.	False, Modification
What anomaly is found in the figure 4.2?	There is an insertion anomaly because every time a customer borrows a book, the customers details will be written again.
True or false. The instances of a subtype must participate in a relationship unique to that subtype.	False, may participate
True or false. Relationships at the supertype level indicate that all subtypes will participate in the relationship.	True
What is a constraint in supertype/subtype that identifies whether an instance of a supertype may simultaneously be a member of two or more subtypes?	Disjointness Constraint
True or false. If supertype A has a relationship with supertype B, the subtypes under supertype A will also have a relationship with supertype B.	True?
True or false. An attribute inheritance is a subtype entity that inherits values of all attributes of the supertype.	True
True or false. A table is qualified to be a relation if it has the same name with other tables.	False, unique name
True or false. An entity integrity means that no primary key attribute may be null.	True
One relation for each entity and one for the associative entity when mapping a ternary or n-ary relationship into relations.	True
In mapping associative entities to relations and if there is an identifier assigned, the default primary key for the association relation is composed of the primary keys of the two entities.	False, identifier not assigned
What happens when a relation has a null value for the primary key?	The null value is not allowed by the database because of Entity Integrity
What is another name for tables in database?	Relation
A candidate key is not allowed to be a primary key.	False, can be a primary key
All relations are in 1NF.	True
A 2NF is a 1NF plus every non-key attribute is fully functionally dependent on the entire primary key.	True
Given the course table, there is no deletion anomaly.	False, 1nf form yung table
Using figure 4.1, map the order entity to a relation. Which among the following is the equivalent relation of the order entity?	ChemicalId SupplierId PurchaseDate TotalCost Amount
True or false. The partial specialization rule in completeness constraints is represented by a double line	False
Using diagram 3, which among the following is true?	The entities administration, teacher and staff are subtypes of the worker
True or false. Relations corresponds to an attribute of an entity type.	False
What is the rule states that any foreign key value (on the relation of the many side) MUST match a primary key value in the relation of the one side?	Referential Integrity
What is a named, two-dimensional table of data?	Relation
The columns of a database table is called an attribute.	True
Which among the following is not true about table anomalies? Baka which of the following is TRUE yung tanong. Kung ganon yung insertion anomaly yung tama.	Modification anomaly forces the changes to not only one value to the data of the table but all similar data involved??? (Mali yung Modification anomaly is similar to deletion anomaly)
A table that pertains to more than one entity type is a well-structured relation.	False
How do you know if a table has no anomalies?	A table should not pertain to more than one entity type.
Read the business rules below and answer the succeeding question. AVA aviation company has many employees. Some employees are pilots and flight attendants. Which among the following are the subtype entities of the employees entity?	pilot and flight attendants
Identify the parts of the SQL worksheet. What is number 2 on the figure 5.1	Run Script
Reduction of training costs is one of the benefits of standardization of SQL.	True
What is a database management system that manages data as a collection of tables in which all relationships are represented by a common values in related tables?	RDBMS
The rename and the update are both commands in data definition language.	False, update is DML
During the database development process the defining of the database is done in the physical design	True
In figure 5.2, in number 2, this is where the results of the SQL statement is shown. (Result tab)	True, SQL Statements yung 1
You can review the definitions of objects at a glance in the connections navigator of your SQL developer.	True
In which year did Oracle markets its first relational database with SQL?	1979
Identify the parts of the SQL worksheet. What is number 8 on the figure 5.1	Autotrace
In 1986, ANSI first released the SQL standard.	True
Constraints prevent the deletion of a table if there are dependencies	True
What statement can you use to put the table back into a read or write mode from a read mode only table?	Read Write
What data type consists of date and time values	Date
Which of the following code will change the Sname column to not null in figure 6A and 6B?	alter table salesman modify sname varchar(30) not null;
Some primary keys are composite keys.	True
The syntax to create a table is CREATE TABLE [schema.]table (column datatype [DEFAULT expr] [column_constraint], ... [table_constraint][,...]);.	True
Creating a constraint can be done at the same time as the creation of the table or after the creation of the table	True
When you drop a table from the database it moves the table to the recycle bin.	True
What is the abbreviation of DDL?	Data Definition Language
Naming table names and column names should not duplicate the name of another object owned by the same user.	True
To execute a line of SQL statement, you can use either execute statement or run script provided it is only one SQL line.	True
To execute a sequence of SQL statements, you should click the run script button instead of the execute statement button.	False
The transaction control has the following commands: commit, rollback and save point.	True
Standardization of SQL allows for later growth/enhancement of the standard.	True
IBM created the system R with sequel.	True, at 1974 - 1979
Identify the parts of the SQL worksheet. What is number 6 on the figure 5.1	SQL History
In which year was the first available RDBMS system on DOS/VSE	1981
What is a foreign key constraint keyword the defines the column in the child table at table-constraint level?	Foreign key
Change the column name of Sname to SalesmanName. Use figure 6A and 6B.	alter table salesman rename column sname to SalesmanName;
In naming tables and column names in database it must begin with the letter and must contain only alphanumeric characters, an underscore, a dollar sign or a number sign.	True
What data type has a variable length character data that is up to two GB	Long
The drop table statement allows you to remove tables from your schema.	True
What statement can you use to put the table into read mode which prevents DDL or DML changes during table maintenance?	Read only
What is a variable length numeric data kind of data type	Number
Given the SQL statement: CREATE TABLE SAMPLE1 (ID NUMERIC(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR2(100)); ,which command makes an attribute a unique key?	Primary key
Relational integrity is enforced via the primary-key to foreign-key match.	True
Improved data sharing and improved data consistency is found in a database approach. True or false?	True
What is the centralized storehouse of metadata?	Repository
The database approach stores a data in a standardized, convenient form. True or false?	True
What is a software system that is used to create, maintain, and provide controlled access to user databases?	Database Management System
E-R models are found in the internal schema of the database. True or false?	False
The internal schema of the database involves the logical and physical structures of the database. True or false?	True
Which schema in the database consists of the user views?	External Schema
Unary relationships should be converted to associative entities. True or false?	False, Ternary Relationships
Which among the following are inappropriate entities of an ERD	Credit report
Perfect identifiers are the attributes that contain locations. True or false?	False, Intelligent Identifier
What is a model that extends the original ER model with new modeling constructs?	Enhanced ERD
When EERDs are difficult to read, the solution to this is to group entities and relationships into entity clusters?	True
Given the entities in diagram 2, if generalization is done, the hair_tie entity will be a subtype of Supertype.	False
True or false. When mapping regular entities to relation, the simple attributes of the entity are mapped directly onto the relation.	True
True or false. The order of the columns in the database table should be sequential.	False
What is a powerful SQL operation for retrieving and modifying data?	Data Manipulation
True or false. A integrity constraint means that no primary key attribute may be null.	True
Changing data in a row forces changes to other rows because of duplication. This is normal in a well-structured relation.	False
A deletion anomaly is when a removing rows from the table may cause a loss of data that would be needed for other future rows.	True
It is said to be that a table is in 1NF, if it is in 2nd normal form and every non-key attribute is fully functionally dependent of the entire primary key.	False, 3nf?
During the maintenance phase of the database development process the controlling of the database is found here, like grant add and revoked commands?	True
One purpose why SQL was standardized was to define data structures and basic operations in SQL.	True
Writing and executing SQL, PL/SQL an SQL *plus statements are done on notepad in SQL developer?	False, SQL Worksheet
What is a set of schemas that constitute the description of a database?	Catalog
The structure that contains descriptions of objects created by a user (base tables, views, constraints)	Schema
Given the SQL statement: CREATE TABLE SAMPLE1 (ID NUMERIC(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR2(100), Valueid numeric(10), constraint sam_fk(valueid) references Value(valueid)); , which command sets an attribute to a foreign key?	sam_fk(valueid)
These enforces rules at the table level and prevents the deletion of a table if there are dependencies	Check? Constraints dapat
What is a data type that has a base of 64 number system representing the unique address of a row in its table	RowID
What is a foreign key constraint keyword that deletes the dependent rows in the child table when a row in the parent table is deleted.	On delete Cascade
The select command is one of the commands of data manipulation language.	True
What is a data type in SQL that stores a moment and event occurs using a definable fraction of a second precision?	Time Stamp
What is a data type that stores exact numbers with a predefined precision and scale of zero	Numeric? Pwede Integer
You can define a constraint of the column level only	False
What is a foreign key constraint keyword that identifies the table and column in the parent table.	References
Reduce dependence on single vendor is one of the benefits of a standardized relational language.	True
What is the datatype that stores binary string values in hexadecimal format?	BLOB
Identify the parts of the SQL worksheet. What is number 7 on the figure 5.1	Execute Explain Plan
What is a data type the store's exact numbers with a defined precision and scale Group of answer choices boolean numeric integer string	numeric
To remove the table and all its data entirely, use purge after the drop table command.	True
Given the SQL statement: CREATE TABLE SAMPLE1 (ID NUMERIC(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR2(100));, which command that makes an attribute not nullable	Not null
Given the SQL statement: ALTER TABLE emp2 ADD CONSTRAINT emp_mgr_fk FOREIGN KEY(manager_id) REFERENCES emp2(employee_id);, the statement adds a new constraint to the table emp2 that sets the manager_id to foreign key of the emp2 table.	True
What SQL statement will create the entity shown in figure 6.1	Create table employee(employeeId numeric(11,0) not null primary key, firstname varchar(100), lastname varchar2(100));
What SQL statement will change the name of the column salesman_id to Sid? Use the figures 6A and 6B.	alter table salesman rename column salesman_id to SId;

Created by: palpakan56

"Know" box contains:
Time elapsed:
Retries: