8.
True or False?
8.The primary key of the Employees table would be posted in the Production Steps table as a foreign key.
26.The primary key of the Production Steps table would be posted in the Production Plan table as a foreign key.
39. The link between the Products and Production Plan tables would be implemented as a linking table.
Homework Answers
| Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
| 8.The primary key of the Employees table would be posted in the Production Steps table as a foreign key. | |
| False. Production authorization? | |
| 26.The primary key of the Production Steps table would be posted in the Production Plan table as a foreign key. | |
| False. Linking Table? | |
| 39. The link between the Products and Production Plan tables would be implemented as a linking table. | |
| False. (PK of products table would be posted in the Production Plan table as a foreign key? or PK products table posted as FK product authorization table? | |
Add Answer to:
8.
True or False?
8.The primary key of the Employees table would be posted in the...
True or False questions: 1. A data type mismatch error would occur when the primary key...
True or False questions: 1. A data type mismatch error would occur when the primary key data data type is auto number and the foreign key in the related table is number. 2. The data type long integer is the same as integer. 3. When using SQL, the SELECT clause isolates tables in the database. 4. A Referential Integrity violation occur when the primary key is null. 5. When an REA model has 7 entities ,2 linking tables, 3 Resource...
A foreign key value must exist in the table where it is a primary key. True?...
A foreign key value must exist in the table where it is a primary key. True? False?
Help Save & En s the following statement correct (true) or incorrect (false)j? with Big Data because querying related Tables (le. tables that are linked using Primary and Foreign Key Relation...
Help Save & En s the following statement correct (true) or incorrect (false)j? with Big Data because querying related Tables (le. tables that are linked using Primary and Foreign Key Relationship containing Big Data requires more secondary memory than what current computers can support." True or Faise True False < Prey 25 of 2SⅢ Next> for working with large Data in tables within relational database MacBook Pro 5 6 8 9 0 0
Help Save & En s the following...
SQL queries and procedures TABLE: Employees Business Rules: EmployeeID is defined as the primary key. Address...
SQL queries and procedures TABLE: Employees Business Rules: EmployeeID is defined as the primary key. Address has been denormalized to include City and State for performance reasons. DeptNbr is a foreign key that references DeptNbr in the Department table Manager is a foreign key that references EmployeeID in the Employees table Data Structure: (EmployeeId, LastName, FirstName, Street, City, State, Zip, DateOfHire, DateOfBirth, JobTitle, Salary, DeptNbr(fk), Manager(fk)) TABLE: Department Business Rules: DeptNbr is defined as the primary key. Data Structure: (DeptNbr,...
7- The values of a Foreign Key column in a table can be referenced to any...
7- The values of a Foreign Key column in a table can be referenced to any column in a second table (Primary key or non-primary key). TRUE FALSE) 8- Using WITH GRANT OPTION clause will result in granting the user the authority to pass ONLY his/her privileges to other users. TRUE FALSE ) 9. To change the characteristics of a column, use the ALTER TABLE command with a SET clause. TRUE FALSE) 10- When inserting new values into a table...
Which of the following describes referential integrity? A. A Primary Key of a relational table must...
Which of the following describes referential integrity? A. A Primary Key of a relational table must not contain a null value B. One fact must not be in multiple places C. The value for a foreign key attribute must either be null or match the one of the data value of that attribute in the table in which the attribute is a primary key D. Referential Integrity is a principle that prevents the use of redundancy, avoids null values and...
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...
If the following appeared in a CREATE TABLE statement FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) true false...
If the following appeared in a CREATE TABLE statement FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) true false - The jable bong crealed must have a column named PeolD true false -The CREATE TABLEWill fail becaue2 tables can ut have a field with the named PersonlD true false -personlD in thi table must be UNIQUE true false- There must be a diftorent table named Pasons Deviousl reated Record Answer
The database(or the tables) are follow: CREATE TABLE employees ( id SERIAL NOT NULL PRIMARY KEY,...
The database(or the tables) are follow: CREATE TABLE employees ( id SERIAL NOT NULL PRIMARY KEY, name TEXT NOT NULL, salary REAL NOT NULL DEFAULT 25000.0 ); CREATE TABLE employee_audit_log ( employee_id INTEGER NOT NULL, occurred_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ); INSERT INTO employees(name, salary) VALUES ('Arnold Schwarznegger', 35000), ('Yuri Gargarin', 27000), ('Anakin Skywalker', 450000), ('Said Faroghi', 15000), ('Zino Holwerda', 8500); 1. Create a trigger for the employees table so that a new row is inserted in employee audit_log...
1) True or False - The foreign keys in a table are linked to the primary...
1) True or False - The foreign keys in a table are
linked to the primary keys in another tables
2_ When we convert this ER to relations, which
relation will represents the check entity:
Check( account_number,check_number, check_date
,recipient,amount,memo)
Check( check_number, check_date ,recipient,amount,memo)
Check( check_date ,recipient,amount,memo)
Check( account_number, check_date
3)
When we convert this ER to relation, we will have:
hint: address is multi-valued attribute
Question 4 options:
customer(cust_id,name)
address(cust_id,street,city,state,zipcode)
customer(cust_id,name, street,city,state,zipcode)
customer(cust_id,name)
address(cust_id,street,city,state,zipcode)
check date account number recipient balance...
Help Save & En s the following statement correct (true) or incorrect (false)j? with Big Data because querying related Tables (le. tables that are linked using Primary and Foreign Key Relationship containing Big Data requires more secondary memory than what current computers can support." True or Faise True False < Prey 25 of 2SⅢ Next> for working with large Data in tables within relational database MacBook Pro 5 6 8 9 0 0
Help Save & En s the following...
7- The values of a Foreign Key column in a table can be referenced to any column in a second table (Primary key or non-primary key). TRUE FALSE) 8- Using WITH GRANT OPTION clause will result in granting the user the authority to pass ONLY his/her privileges to other users. TRUE FALSE ) 9. To change the characteristics of a column, use the ALTER TABLE command with a SET clause. TRUE FALSE) 10- When inserting new values into a table...
If the following appeared in a CREATE TABLE statement FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) true false - The jable bong crealed must have a column named PeolD true false -The CREATE TABLEWill fail becaue2 tables can ut have a field with the named PersonlD true false -personlD in thi table must be UNIQUE true false- There must be a diftorent table named Pasons Deviousl reated Record Answer
1) True or False - The foreign keys in a table are
linked to the primary keys in another tables
2_ When we convert this ER to relations, which
relation will represents the check entity:
Check( account_number,check_number, check_date
,recipient,amount,memo)
Check( check_number, check_date ,recipient,amount,memo)
Check( check_date ,recipient,amount,memo)
Check( account_number, check_date
3)
When we convert this ER to relation, we will have:
hint: address is multi-valued attribute
Question 4 options:
customer(cust_id,name)
address(cust_id,street,city,state,zipcode)
customer(cust_id,name, street,city,state,zipcode)
customer(cust_id,name)
address(cust_id,street,city,state,zipcode)
check date account number recipient balance...
Most questions answered within 3 hours.
-
Write a balanced chemical equation for the oxidation reaction
between Caro’s acid (H2SO5) and CN– ion...
asked 1 minute ago -
Calculate the number of valence electrons for
[Mo(C6H6)(CO)3]
asked 12 minutes ago -
Which of the following are true about the strength of the
association between two variables?
1-...
asked 8 minutes ago -
You are a monopolist and know that your consumers have a linear
demand curve. At what...
asked 7 minutes ago -
Raising a heavy load requires work. Raising it in half the time
requires:
asked 14 minutes ago -
MGT-201: Marketing Management
Before deciding on the structure of the channel marketers must
take several factors...
asked 13 minutes ago -
1. ACLs allow a router to control traffic within a network. The
concept is very similar...
asked 15 minutes ago -
35. When the electron in a hydrogen atom falls from its first
excited energy level to...
asked 16 minutes ago -
A man is dragging a box of mass "m" by using a rope which rests
on...
asked 33 minutes ago -
Liquid octane
(CH3(CH2)6CH3) will
react with gaseous oxygen (O2) to produce gaseous carbon
dioxide (CO2) and...
asked 34 minutes ago -
For the reaction N2(g) +
O2(g) --> 2NO(g), if the initial
concentration of NO was 0.00M...
asked 37 minutes ago -
On a recent quiz, the class mean was 75 with a standard
deviation of 2.2. Calculate...
asked 53 minutes ago