Questions 44 through 50 relate to the following relational database. The Book table (named Book_T), given below, is one of the tables in a relational database used by a bookstore. ISBN Title PubDate PubID Cost Retail Discount Category 0401140733 Revenge of Mickey 12/14/2005 1 14.2 22   Family Life 8843172113 Database Implementation 06/04/2003 3 31.4 55.95   Computer 3437212490 Cooking with Mushrooms 02/28/2004 4 12.5 19.95   Cooking 3957136468 Holy Grail of Oracle 12/31/2005 3 47.25 75.95 3.8 Computer 2491748320 Painless Child-Rearing 07/17/2004 5 48 89.95 4.5 Family Life 2147428890 Shortest Poems 05/01/2005 5 21.85 39.95   Literature The domain definitions for the attributes of the book table are given below. Attribute Description Data Type ISBN Unique identifier of the book (primary key) VARCHAR2(10) Title Title of the book VARCHAR2(30) PubDate Publication date of the book DATE PubID Publisher ID of the book NUMBER(2) Cost Cost of a copy of the book in dollars NUMBER(5,2) Retail Sale price of a copy of the book in dollars NUMBER(5,2) Discount Discount amount in dollars from retail price NUMBER(5,2) Category Category of the book VARCHAR2(15) What is the output generated by the SQL statement below?               SELECT ISBN, Title, Retail  Price               FROM Book_T;

Questions 1 through 4 relate to the following ER diagram. The following ER diagram represents two entities and a relationship between them. Assume that we want to redraw the ER diagram above using an associative entity.  We come up with the following partial solution, with circled numbers in the diagram indicating the incomplete parts. Each number is referred to in a question with the same question number. Please refer to these numbers to answer the questions. What should be the relationship name on the line between the associative entity and the PRODUCT entity?

Questions 14 through 20 relate to the following ER diagram. This ER model captures the data needs of a pharmacy, representing the associations among (i) drugs, (ii) side effects, (iii) interactions, (iv) conditions, and (v) ingredients.  Please answer the questions about this conceptual model. Which entity is an optional participant in a relationship with which other entity?

Questions 32 through 35 relate to the following ER diagram. Data domain definitions for the attributes are given below. Attribute Description Domain Nurse ID Set of possible nurse IDs Fixed Character: size 5 Nurse Name Set of possible nurse names Variable Character: size 20 Nurse Birth Date Set of possible nurse birth dates Date Date Assigned Set of possible assignment dates Date Center ID Set of possible care center IDs  Number: size 4 (no decimal) Center Location Set of possible care center locations Variable Character: size 10 (This column can only take one of three values: Dallas, Plano, Allen) Based on the conceptual model and the domain definitions, we decided to create tables using SQL DDL statements for NURSE and CARE CENTER relations to build the database.  We came up with the following table definitions (based on the relational schema, which is not shown here). CREATE TABLE Nurse_T (NurseID                            A,NurseName                       B,NurseBirthDate                  C, CONSTRAINT Nurse_PK                   D );CREATE TABLE CareCenter_T (CenterID                            E,CenterLocation                    F, CONSTRAINT CareCenter_PK           G ); Which of the following SQL DDL code should be inserted in place of ‘F’?

Questions 32 through 35 relate to the following ER diagram. Data domain definitions for the attributes are given below. Attribute Description Domain Nurse ID Set of possible nurse IDs Fixed Character: size 5 Nurse Name Set of possible nurse names Variable Character: size 20 Nurse Birth Date Set of possible nurse birth dates Date Date Assigned Set of possible assignment dates Date Center ID Set of possible care center IDs  Number: size 4 (no decimal) Center Location Set of possible care center locations Variable Character: size 10 (This column can only take one of three values: Dallas, Plano, Allen) Based on the conceptual model and the domain definitions, we decided to create tables using SQL DDL statements for NURSE and CARE CENTER relations to build the database.  We came up with the following table definitions (based on the relational schema, which is not shown here). CREATE TABLE Nurse_T (NurseID                            A,NurseName                       B,NurseBirthDate                  C, CONSTRAINT Nurse_PK                   D );CREATE TABLE CareCenter_T (CenterID                            E,CenterLocation                    F, CONSTRAINT CareCenter_PK           G ); Which of the following SQL DDL code should be inserted in place of ‘D’?

When varying the substrate concentration at a fixed concentration of enzyme it is observed that at low concentrations of substrate the reaction is ________, while at high concentrations of substrate the reaction is ________.

Allosteric modulators seldom resemble the substrate or product of the enzyme. What does this observation show?

Aspartate transcarbamoylase (ATCase), an enzyme involved in pyrimidine biosynthesis, is an example of an allosterically-regulated enzyme with multiple subunits. a) Describe the two types of subunits that comprise the ATCase enzyme. b) Explain how each subunit type contributes to the function of ATCase.

In a certain enzyme-catalyzed reaction the following steps occur:1. A phosphate group on substrate A is transferred to a side chain of an active site residue of the enzyme.2. The dephosphorylated form of substrate A dissociates from the enzyme.3. Substrate B enters the active site and is phosphorylated with simultaneous regeneration of the enzyme in its original form.What kind of kinetic mechanism is described?

Using the worksheet shown in the screenshot below, what value would be returned by the following formula? (Be sure to type the value exactly as it appears in the worksheet.) =INDEX($B$2:$B$872,MATCH(“Riverbend Music Center”,$C$2:$C$872,0))