All Matches
Solution Library
Expert Answer
Textbooks
Search Textbook questions, tutors and Books
Oops, something went wrong!
Change your search query and then try again
Toggle navigation
FREE Trial
S
Books
FREE
Tutors
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Ask a Question
Search
Search
Sign In
Register
study help
computer sciences
databases
Questions and Answers of
Databases
Consider the following relation instance of the SPORT relation schema.a. What is the minimal cover of functional dependencies that exists in SPORT?b. What is (are) the candidate key(s) of SPORT?c. If
What is a multi-valued dependency?
What is the definition of fifth normal form?
Is the relation instance SHIRT in Exercise 2 in 5NF? If the answer is yes, explain. If the answer is no, provide a solution.
Consider the universal relation schema STOCK (Symbol, Company, Exchange, Investor, Date, Price, Broker, Dividend) and the following dependencies set:fd: Symbol → {Company, Exchange, Dividend}mvd:
Given the schema SCHEDULE (Prof, Office, Major, {Book}, Course, Quarter) along with:F: fd1: Prof → {Office, Major} and D: mvd: Prof --->> Booka. Identify the primary key of SCHEDULE such that
This exercise is based on four different inventory relation schemas: P, Q, R, and S. An instance of each relation schema is given below, each of which reflects a different design objective.a.
Consider the instance of the relation SHIRT (Shirt#, Color, Size) where Shirt# is equivalent to a style number (e.g., style number 341 might be a shirt with a button-down collar while style number
Which of the inference rules for multi-valued dependencies supports the statement that multi-valued dependencies (MVDs) are a generalization of functional dependencies (i.e., a functional dependency
Consider a revised instance of the SHIRT relation in Exercise 2.Does this version of SHIRT possess the multi-valued dependency Shirt# -->> Color|Size? Why or why not?
Consider the relation schema STUDENT (Sid, Shoe_size, Marital_status)F: fd1: Sid → Shoe_size;...................fd2: Sid → Marital_statusa. Does STUDENT possess a multi-valued dependency? Why or
How are multi-valued dependencies incorporated into the definition of fourth normal form (4NF)?
Consider the relation instance STUDENT (Major, Stu_id, Activity, Name, Phone)a. Identify all multi-valued dependencies in STUDENT.b. Describe insertion, deletion, and update anomalies that accompany
Consider the relation instance COURSE_OFFERED (Course, Teacher, Text)a. Does COURSE_OFFERED possess a multi-valued dependency? If the answer is yes, show how this multi-valued dependency occurs. How
What is a join dependency and in what way is it related to a multi-valued dependency?
Discuss the differences between a relation and a table.
You must have completed Exercise 9 before beginning this exercise, and thus have used the SQL Data Definition Language to create tables for the three relations DRIVER, TICKET_TYPE, and TICKET. Use
This exercise is based on the data sets associated with Figure 2.25 in Chapter 2.a. Use the SQL Data Definition Language to create a relational schema that consists of the following three
The purpose of this exercise is to give you an opportunity to create the tables for Bearcat Incorporated. The tables themselves are based on the relations that appear in the following figure.L1:
Describe the SQL clauses used in the definition of:a. A primary key constraintb. An alternate key constraintc. A foreign key constraintd. A check constraint
Describe the types of modifications that can be made to a table using the ALTER TABLE statement.
Consider a relational schema with three relation schemas: DRIVER (Dr_license_no, Dr_name, Dr_city, Dr_state), TICKET_TYPE (Ttp_offense, Ttp_fine) and TICKET (Tic_ticket_no, Tic_ticket_date,
The series of tasks in this exercise is based on the following ER diagram and its associated logical schema. a. Write appropriate CREATE TABLE statements for the logical schema. Be sure to define all
What is the purpose of the Union, Intersection, and Difference operations?
What is the difference between the result obtained from a section operation versus a Projection operation?
What is a Join operation? What is meant when it is said that two relations are join compatible? What is the difference between an Inner Join operation and an Outer Join operation?
This question is based on the four relations shown below. Show the results along with the relational algebra expressions for the following four retrieval requests?a. Display the products and their
Consider the TUTOR, TUTOR_ASSIGNMENT and COURSE relations that appear below. Show the results and the relational algebra expressions for the following four retrieval requests.a. What are the Course
Describe the six clauses that can be used in the syntax of the SQL Select statement. Which two clauses must be part of each Select statement?
What is the difference between a Select statement that used Count (*) and a select statement that uses count (Column name)? How does Count (Column name) differ from Count (Distnct column name)?
Why is it important to be aware of the distinction between the Char and Varchar data types?
What is the difference between a Cross Join, an Inner Join, and an Outer Join?
What is the difference between the JOIN ... USING and the JOIN ... ON approaches for joining tables? Which approach must be used if the requirement that attributes have unique names over the entire
What is a subquery and where can subqueries appear within an SQL Select statement?
You must have completed Exercise 10 in Chapter 10 for beginning this exercise and thus have used the SQL Data Definition Language to create tables for the three relations DRIVER, TICKET_TYPE, and
You must have completed Exercise 11 of Chapter 10 before beginning this exercise, and thus have used the SQL Data Definition Language to populate the tables for the three relations COMPANY, STUDENT,
What is the difference a select statement used in conjunction with the relational algebra Selection operation and a Select statement in conjunction with the relational algebra Projection operation?
Of what value is the use of parentheses when making use of the rules of operator precedence?
When must a Group by clause be used in a query?
Display the subassemblies of a snow shovel in the same top to bottom order as shown there: The level 2 nodes need not be displayed in the same left to right order as shown in the figure:
Display the number of pounds of milk produced in each region each year along with the same totals you displayed in your answer to the previous question. Use the GROUPING function and the DECODE
Modify the pervious query to that instead of displaying as one of the totals the total number pounds of milk produced in each region, the total number of pounds of milk produced in each year across
How many rows of output would be produced if the ROLLUP used in your query were to take the following form: GROUP BY ROLLUP (YEAR, MONTH, REG_NAME)? Write a query to verify your result?
How many rows of output would be produced if the ROLLUP used in your query were to take the following form: GROUP BY ROLLUP (MONTH, YEAR, REG_NAME)? Write a query to verify your result?
Display the number of pounds of milk produced in each region each year along with the total number of pounds produced in each region, the total number of pounds of milk produced during each year and
Display only the total number of pounds of milk produced in each region and in each year. Order the results by the totals generated?
Display the number of pounds of milk produced in each year along with the ranking of each year in terms of the number of pounds of milk produced. The rankings should be displayed in descending order
Display the number of pounds of milk produced in each region during the 2006-2010 period along with the ranking of each region in terms of the number of pounds of milk produced. The ranks should be
Display the number of pounds of milk produced in each month during the 2006-2010 period along with the ranking of each month in terms of the number of pounds of milk produced. The ranks should be
Display a separate set of rankings for the number of pounds of milk produced in each month for each region?
Display all of the assemblies for which a snow shovel is a subassembly?
Display the sum along with the cumulative sum of the production of milk across the regions for the 2006-2010 period starting with January and ending the December?
Display the sum along with a three-month moving average of the production of milk across the regions for the 2006-2010 period starting with January and ending in December?
Display the sum along with a three month moving average of the production of milk across the regions of the 2006-2010 period starting with January, 2006 and ending in December, 2010?
Write an SQL query that makes use of the Model clause to estimate the monthly production of milk in 2011 for each region to be equal to the average of the production of milk for that month during the
Display all of the assemblies for which a Bracket assembly is a subassembly?
Display all subassemblies of a snow shovel along with the number of required units of each. Indent each component in such a way as to appropriately depict the hierarchical structure?
Display the entire composition of all subassemblies of the Shovel complete that are either manufactured by Sears or use a component manufactured by Sears?
Display all subassemblies manufactured by Sears that require more than 1 unit?
Display all subassemblies and their components where the subassembly contains the words "Top Handle"?
Display the total number of pounds of milk produced in each region during the 2006-2010 time period?
Display the number of pounds of milk produced in each region during the 2006-2010 time period. In addition, include in the output you display the total number of pounds of milk produced across all
Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2.
What is the difference between controlled and uncontrolled redundancy?
Specify all the relationships among the records of the database shown in Figure 1.2.
Give some additional views that may be needed by other user groups for the database shown in Figure 1.2.
Cite some examples of integrity constraints that you think can apply to the database shown in Figure 1.2.
Give examples of systems in which it may make sense to use traditional file processing instead of a database approach.
Consider Figure 1.2. a. If the name of the 'CS' (Computer Science) Department changes to 'CSSE' (Computer Science and Software Engineering) Department and the corresponding prefix for the course
Think of different users for the database of Figure 1.2. What type of applications would each user need? To which user category would each belong and what type of interface would they need?
If you were designing a Web-based system to make airline reservations and to sell airline tickets, which DBMS Architecture would you choose from Section 2.5? Why? Why would the other architectures
Consider Figure 2.1. In addition to constraints relating the values of columns in one table to columns in another table, there are also constraints that impose restrictions on values in a column or
Suppose each of the following Update operations is applied directly to the database of Figure 3.6. Discuss all integrity constraints violated by each operation, if any, and the different ways of
Consider the AIRLINE relational database schema shown in Figure 3.8, which describes a database for airline flight information. Each FLIGHT is identified by a flight NUMBER, and consists of one or
Consider the relation CLASS(Course#, Univ_Section#, InstructorName, Semester, BuildingCode, Room#, TimePeriod, Weekdays, CreditHours). This represents classes taught in a university with unique
Consider the following six relations for an order-processing database application in a company: CUSTOMER (Cust#, Cname, City) ORDER (Order#, Odate, Cust#, Ord_Amt) ORDER_ITEM (Order#, Item#,
Consider the following relations for a database that keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, Start_Year, Dept_No) TRIP (SSN, From_City, To_City,
Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT (SSN, Name, Major, Bdate) COURSE (Course#, Quarter,
Database design often involves decisions about the storage of attributes. For example a Social Security Number can be stored as a one attribute or split into three attributes (one for each of the
Consider a STUDENT relation in a UNIVERSITY database with the following attributes (Name, SSN, Local_phone, Address, Cell_phone, Age, GPA). Note that the cell phone may be from a different city and
Recent changes in privacy laws have disallowed organizations from using SSN to identify individuals unless certain restrictions are satisfied. As a result, most US universities cannot use SSNs as
Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. What are the referential integrity constraints that should hold on the schema? Write appropriate SQL DDL statements to
Repeat Exercise 4.5, but use the AIRLINE schema of Figure 3.8. In exercise 4.5 What are the referential integrity constraints that should hold on the schema? Write appropriate SQL DDL statements to
Consider the LIBRARY relational database schema of Figure 4.6. Choose the appropriate action (reject, cascade, set to null, set to default) for each referential integrity constraint, both for the
Write appropriate SQL DDL statements for declaring the LIBRARY relational database schema of Figure 4.6. Specify the keys and referential triggered actions.
How can the key and foreign key constraints be enforced by the DBMS? Is the enforcement technique you suggest difficult to implement? Can the constraint checks be executed in an efficient manner when
Specify the updates of Exercise 3.11 using the SQL update commands. In exercise 3.11 (a) Insert < 'Robert', 'F', 'Scott', '943775543', '21-JUN-42', '2365 Newcastle Rd, Bellaire, TX', M, 58000,
Specify the following queries in SQL on the database schema of Figure 1.2. (a) Retrieve the names of all senior students majoring in 'COSC' (computer science). (b) Retrieve the names of all courses
Write SQL update statements to do the following on the database schema shown in Figure 1.2. (a) Insert a new student in the database. (b) Change the class of student 'Smith' to 2. (c) Insert a new
Consider the EMPLOYEE table's constraint EMPSUPERFK as specified in Figure 4.2 is changed to read as follows:CONSTRAINT EMPSUPERFKFOREIGN KEY (SUPERSSN) REFERNCES EMPLOYEE(SSN)ON DELETE CASCADE ON
Specify the following additional queries on the database of Figure 3.5 in SQL. Show the query results if applied to the database of Figure 3.6. (a) For each department whose average employee salary
Specify the following queries in SQL on the database schema of Figure 1.2. (a) Retrieve the names and major departments of all straight-A students (students who have a grade of A in all their
In SQL, specify the following queries on the database specified in Figure 3.5 using the concept of nested queries and the concepts described in this chapter. a. Retrieve the names of all employees
Show the result of each of the sample queries in Section 6.5 as it would apply to the database state in Figure 3.6.
Specify the following queries on the COMPANY relational database schema shown in Figure 3.5, using the relational operators discussed in this chapter. Also show the result of each query as it would
Consider the LIBRARY relational schema shown in Figure 6.14, which is used to keep track of books, borrowers, and book loans. Referential integrity constraints are shown as directed arcs in Figure
Consider the two tables T1 and T2 shown in Figure 6.15. Show the results of the following operations:
Specify queries (a), (b), (c), (e), (f), (i), and (j) of Exercise 6.16 in both tuple and domain relational calculus.
Specify queries c, d, and e of Exercise 6.18 in both tuple and domain relational calculus.
Rewrite the domain relational calculus queries that followed Q0 in Section 6.7 in the style of the abbreviated notation of Q0A, where the objective is to minimize the number of domain variables by
Showing 2200 - 2300
of 2962
First
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30