Computer Science Homework Solutions
Problem
#182624

Database processing

I'm reworking some online college homework and I can't get these questions.  

1.  Which of the following is not a step in the database design process?

Creating tables and columns from entities and attributes
Selecting primary keys
creating constraints and triggers

2.  When an entity has a relationship to itself, we have a

archetype/instance relationship
recursive relationship
all the above

3.  Given a table with the structure:  EMPLOYEE (Empno, Name, Salary, HireDate), which of the following is not a valid ANSI SQL command?

SELECT COUNT(*) FROM EMPLOYEE WHERE Salary<30000;
SELECT COUNT(EmpNO) FROM EMPLOYEE;
SELECT HireDate, COUNT(*) FROM EMPLOYEE WHERE SALARY<30000;

4.  To represent an association pattern in an ER model, _____

create a new ID-dependent entitiy with a 1:1 relationship to one other entity

create a new weak, but not ID-dependent entity with a 1:1 relationship to one other entity

create a new ID-dependent entity with a 1:N relationship to one of two parent entities.

5.  The presence of one or more foreign keys in a relation prevents

the elimination of duplicated data
more complex SQL for mulitable subqueries and joins
all the above

6.  Many-to-Many relationships are represented by

two tables with an M:N relationship
two tables with a 1:N relationship
by an intersection table which has M:N relationships with the two tables

Solution
What is this?
By OTA - Overall OTA Rating
Yupei Xiong, PhD - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
  • Plain text response
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Database Design - 1. How are recursive relationships handled? 2. Discuss surrogate keys. 3. Describe the six default referential integrity actions. 4. How are N:M relationships implemented? ...
  • Example of Database Relationships - Look for an example of a one-to-one relationship, an example of a one-to-many relationship, and an example of a many-to-many relationship in a newspaper, magazine, book, or everyday situation you enco ...
  • Give examples of the following Database relationships: one-to-one one-to-many many-to-many - Look for an example of a one-to-one relationship, an example of a one-to-many relationship, and an example of a many-to-many relationship in a newspaper, magazine, book, or everyday situation you enco ...
  • Store and Region - 1. Describe the type(s) of relationship(s) between STORE and REGION. Draw the entity relationship diagram for the relationship between STORE and REGION. Draw the relational schema for the relationship ...
  • Create the keys and relationships between tables for the Driver LOG - Using MS Access, create the keys and relationships between tables for the Driver LOG from the file attached.
Browse