Homework Answers
1. A. composite key. A key that contains more than one attribute is called a composite key.
2. TRUE, YES Null values can cause problems because they are ambiguous.
3. TRUE, YES In the normalization process, it is necessary to identify all the determinants in a relation.
5. False, A relational database DOES NOT stores data in the form of lists.
6. C) order they are listed in following SELECT. The order of the columns returned by an SQL SELECT statement are determined by the order they are listed in following SELECT.
7.FALSE. Although users use database systems, they are not considered part of a database system.
Add Answer to:
24) A key that contains more than one attribute is called a(n) A) composite key B)...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
The employee is table, the best candidate for primary key is Select one: a. Department ID...
The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than one attribute. Select one: True False Question 3 A foreign key allows you to join two tables. Select one: True False Question 4 Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key? Select...
Question 29 What entity type is used to convert a many-to-many relationship to two one-to-many relationships?...
Question 29 What entity type is used to convert a many-to-many relationship to two one-to-many relationships? repeating entity intersection entity associative entity attributive entity Question 30 A many-to-many relationship can be directly modeled in a relational database such as Microsoft Access. True False Question 31 Which order is correct for the designer to normalize a data structure? I. Remove all repeating groups and identify the primary key. II. Remove any transitive dependencies. III. Remove all partial dependencies and place them...
ChangeRequest(CRID, CRType, CRTitle, CROriginDate, CRPriority, CRNeedEvent, CRStatus) NeedByEvent(Event) CRPrevState(CRID, CRState, StartDate, EndDate) CRAssigned(CRID, EmpID, StartDate, EndDate)...
ChangeRequest(CRID, CRType, CRTitle, CROriginDate, CRPriority, CRNeedEvent, CRStatus) NeedByEvent(Event) CRPrevState(CRID, CRState, StartDate, EndDate) CRAssigned(CRID, EmpID, StartDate, EndDate) Employees(EmpID, FirstName, LastName, JobTitle) ChangeRequest(CRID, CRType, CRTitle, CROriginDate, CRPriority, CRNeedEvent, CRStatus) The CRID is the primary key, it is unique, and it is an positive integer The CRType may be one of two values: "Deficiency" or "Enhancement" CRTitle is a variable length string that may be up to 2048 characters CROriginDate is a date CRPriority is an integer that may assume a value of...
QUESTION 8 Which layer of the TCP/IP hierarchy presents incoming messages to the computer user? a....
QUESTION 8 Which layer of the TCP/IP hierarchy presents incoming messages to the computer user? a. Network b. Link c. Transport d. Application 2.5 points QUESTION 9 A relational database is a collection of one or more tables that are related by key values. True False 2.5 points QUESTION 10 Which standards organization produced the OSI reference model for internet communication? a. IEEE b. ISO c. ANSI 2.5 points QUESTION 11 Which of the following is used...
database and sql problme THE QUESTIONS 3, 4,5 and 6 REFER TO THE RELATIONAL TABLES LISTED...
database and sql problme
THE QUESTIONS 3, 4,5 and 6 REFER TO THE RELATIONAL TABLES LISTED BELOW CREATE TABLE Department ( DECIMAL(5) VARCHAR(30) CHAR(5) DATE NOT NULL NOT NULL NOT NULL * Department number /*Department name * Department manager number */ /Manager start date DNumber DName Manager MSDate CONSTRAINT Department_PK PRIMARY KEY(DNumber) CONSTRAINT Department_CK UNIQUE(DName) CREATE TABLE DeptLocation DECIMAL(5) VARCHAR(50) NOT NULL NOT NULL DNumber * Department number */ * Department location */ Address CONSTRAINT DeptLocation_PK PRIMARY KEY(DNumber, Address) CONSTRAINT...
DROP TABLE EMPLOYEE; DROP TABLE JOB; DROP TABLE EMP; DROP TABLE EMP_1; DROP TABLE EMP_2; CREATE...
DROP TABLE EMPLOYEE;
DROP TABLE JOB;
DROP TABLE EMP;
DROP TABLE EMP_1;
DROP TABLE EMP_2;
CREATE TABLE JOB(JOB_CODE CHAR (3) PRIMARY KEY, JOB_DESCRIPTION
VARCHAR (20) NOT NULL,JOB_CHG_HOUR NUMBER (5,2) NOT
NULL,JOB_LAST_UPDATE DATE NOT NULL);
INSERT INTO JOB
VALUES('500','Programmer','35.75','20-Nov-2017');
INSERT INTO JOB VALUES('501','System
Analyst','96.75','20-Nov-2017');
INSERT INTO JOB VALUES('502','Database
Designer','125.00','24-Mar-2018');
CREATE TABLE EMPLOYEE(EMP_NUM CHAR (3) PRIMARY KEY,EMP_LNAME
VARCHAR (15) NOT NULL,EMP_FNAME VARCHAR (15) NOT NULL, EMP_INITIAL
CHAR (1),EMP_HIREDATE DATE NOT NULL,JOB_CODE CHAR (3), EMP_YEARS
NUMBER (2),FOREIGN KEY (JOB_CODE) REFERENCES JOB (JOB_CODE));
INSERT...
If the focus in a form moves from left to right and you want the focus...
If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____. . a. . sort order . b. . tab order . c. . form layout . d. . focus grouping What do you change when you drag the right border of a form in Form Design view? . a. . the layout of the form . b. . the width of the form ....
Match the type of schedule listed with the description following. Schedule types may be used more than once a. Activity on arrow (AOA) b. Activity on node (AON) C. Matrix d. Bar chart 40 Grap...
Match the type of schedule listed with the description following. Schedule types may be used more than once a. Activity on arrow (AOA) b. Activity on node (AON) C. Matrix d. Bar chart 40 Graphically the simplest Graphic style makes it adaptable to high-rise construction 42.Utilizes i-j notation 43 Could also be termed precedent notation Would be used for a summary report to the owner Questions 45-49 Match the terms listed with their description. Terms may be used only once...
A. Issues [1] In addition to damages for one year's notice period, can a trial judge...
A. Issues [1] In addition to damages for one year's notice period, can a trial judge award significant damages for the mere fact of an employee's dismissal, or for the stigma that that dismissal brings? Or for the employer thereafter competing with the ex-employee for the clients, before the ex-employee has got a new job? B. Basic Facts [2] This is an appeal from 2009 ABQB 591 (CanLII), 473 A.R. 254. [3] Usually a judgment recites facts before law. But...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
database and sql problme
THE QUESTIONS 3, 4,5 and 6 REFER TO THE RELATIONAL TABLES LISTED BELOW CREATE TABLE Department ( DECIMAL(5) VARCHAR(30) CHAR(5) DATE NOT NULL NOT NULL NOT NULL * Department number /*Department name * Department manager number */ /Manager start date DNumber DName Manager MSDate CONSTRAINT Department_PK PRIMARY KEY(DNumber) CONSTRAINT Department_CK UNIQUE(DName) CREATE TABLE DeptLocation DECIMAL(5) VARCHAR(50) NOT NULL NOT NULL DNumber * Department number */ * Department location */ Address CONSTRAINT DeptLocation_PK PRIMARY KEY(DNumber, Address) CONSTRAINT...
DROP TABLE EMPLOYEE;
DROP TABLE JOB;
DROP TABLE EMP;
DROP TABLE EMP_1;
DROP TABLE EMP_2;
CREATE TABLE JOB(JOB_CODE CHAR (3) PRIMARY KEY, JOB_DESCRIPTION
VARCHAR (20) NOT NULL,JOB_CHG_HOUR NUMBER (5,2) NOT
NULL,JOB_LAST_UPDATE DATE NOT NULL);
INSERT INTO JOB
VALUES('500','Programmer','35.75','20-Nov-2017');
INSERT INTO JOB VALUES('501','System
Analyst','96.75','20-Nov-2017');
INSERT INTO JOB VALUES('502','Database
Designer','125.00','24-Mar-2018');
CREATE TABLE EMPLOYEE(EMP_NUM CHAR (3) PRIMARY KEY,EMP_LNAME
VARCHAR (15) NOT NULL,EMP_FNAME VARCHAR (15) NOT NULL, EMP_INITIAL
CHAR (1),EMP_HIREDATE DATE NOT NULL,JOB_CODE CHAR (3), EMP_YEARS
NUMBER (2),FOREIGN KEY (JOB_CODE) REFERENCES JOB (JOB_CODE));
INSERT...
Match the type of schedule listed with the description following. Schedule types may be used more than once a. Activity on arrow (AOA) b. Activity on node (AON) C. Matrix d. Bar chart 40 Graphically the simplest Graphic style makes it adaptable to high-rise construction 42.Utilizes i-j notation 43 Could also be termed precedent notation Would be used for a summary report to the owner Questions 45-49 Match the terms listed with their description. Terms may be used only once...
A. Issues [1] In addition to damages for one year's notice period, can a trial judge award significant damages for the mere fact of an employee's dismissal, or for the stigma that that dismissal brings? Or for the employer thereafter competing with the ex-employee for the clients, before the ex-employee has got a new job? B. Basic Facts [2] This is an appeal from 2009 ABQB 591 (CanLII), 473 A.R. 254. [3] Usually a judgment recites facts before law. But...
Most questions answered within 3 hours.
-
In winter a lake has a 0.35 m thick ice layer over 1.10 m of
water....
asked 25 minutes ago -
Assuming the following has been encrypted with a Vigenere cipher
below, use the method(s) and assumptions...
asked 50 minutes ago -
How would I use switch statements to write a program that will
take an input of...
asked 41 minutes ago -
Imagine a reaction in which methane gas combusts at a constant
pressure of 1 atm and...
asked 52 minutes ago -
Two parallel wires (each 12 m in length) are separated by a
distance of 0.065 m...
asked 49 minutes ago -
Suppose there were three masses at the corner of uniform
equilateral triangle. The masses are m1...
asked 51 minutes ago -
Situation: A building that is 618 m above the ground floor. How
many times would a...
asked 55 minutes ago -
help me and discuss one successful and one
unsuccessful international company/busines in Indonesia.whyit
succeed and why...
asked 1 hour ago -
I- Choose the best answer
Which of the following statements about the structure and
packaging of...
asked 1 hour ago -
1. A sample of 144 incoming freshman found that 45 of them
scored more than 550...
asked 1 hour ago -
Kc is 2.35 × 1018 at 25 °C for the formation of iron(III)
oxalate complex ion....
asked 1 hour ago -
Team Values – Discuss as a team what values are important.
Develop a statement or itemised...
asked 1 hour ago