CSCI 6950: Advanced Database Design and Administration - IT Computer Science Assignment Help

Assignment Task

1. Answer the following multiple choice questions.

1. _____ provide a description of the data characteristics and the set of relationships that link the data found within the database.

a) Queries

b) End-user data

c) Metadata

d) Schemas

 

2. Redundancy refers to what database condition?

a) A primary key is repeated in another table as a foreign key

b) All data is stored in tables

c) The same data is recorded in more than one place in the same database

d) You have more than one database devoted to the same thing

 

3. Which of the following is the best definition for a database attribute?

a) A principle the database must follow

b) One of the features of a database

c) Something the database is concerned about for which data can be stored

d) Something that describes some part of an entity

 

4. Which of the following is true of NoSQL databases?

a) They do not support distributed database architectures.

b) They are not based on the relational model.

c) They are geared toward transaction consistency rather than performance.

d) They do not support very large amounts of sparse data.

 

5. Referential _____ dictates that the foreign key must contain values that match the primary key in the related table, or must contain null.

a) integrity

b) uniqueness

c) model

d) attribute

 

6. What best describes the function of a foreign key?

a) A foreign key is a key that doesn't belong in the table

b) A foreign key is at the primary key of one table repeated in another table in order to create a relationship between the tables

c) A foreign key is redundant data

d) A foreign key is a field telling what language the data is in

 

7. The _____ special operator is used to check whether an attribute value is null.

a) NOT NULL

b) IS NULL

c) LIKE

d) BETWEEN

 

8. The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____.

a) SUM

b) MIN

c) COUNT

d) MAX

 

9. The data format for SQL character is _____.

a) CHAR and VARCHAR

b) Alphanumeric

c) CHAR only

d) VARCHAR only

 

10. The SQL command that allows a user to list the contents of a table is _____.

a) COMMIT

b) INSERT

c) UPDATE

d) SELECT

 

2.  a. Explain the shared property for databases.

b. What are the requirements for union compatibility?

 

3. What is meant by a recursive relationship type? Give one example of a recursive relationship type.

 

 

4. Specify all the referential integrity constrains that hold on the COMPANY schema above. Write a referential integrity constraint as R.A --> S.B whenever attribute A of relation R forms a foreign key that references the primary key of relation S.

 

5. Write the following SQL queries:

a. Write the SELECT statement to retrieve the first name, last name and address of employees who work for the Research department.

b. Write a SELECT statement that retrieves all employees whose address is in Huston, Texas.

c. Write a SELECT statement that retrieves all distinct salary values.

d. Write a SELECT statement that calculates the total number of employees and average salary in each department and displays it together with the name of the department. Order the departments by the total number of employees in descending order.

e. Explain what this query returns.

 

6. a. Write the DDL CREATE TABLE command to create a table called RaceHorse for a Horse Racing Database. The table schema is given below, taking into consideration the following constraints:

• hName and type can’t be null.

• purchasePrice has to be greater than $1,000.

RaceHourse(regNum, hName, gender, type, purchaseDate, purchasePrice, trainedBy, stabledAt)

 

b. Write the DDL INSERT command to insert the following row in the RaceHorse table you created above.

c. Write the DDL command used to remove the RaceHorse table from the database.

 

This CSCI 6950-IT Computer Science Assignment has been solved by our IT Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered.

You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.