EmployeeID is the primary key for the relation below. Which column violates a rule (characteristic) of a relation? Employee Relation EmployeeID Department PhoneNum PhoneNum 300 Finance 321-299-1234 407-999-2300 200 Sales 407-222-9090 321-365-0912 400 Sales 407-807-1124 407-453-2294 100 HR 321-934-2034 Group of answer choices The column named PhoneNum because you can’t have two columns with the same name. All the columns are valid. The EmployeeID column because the ID numbers are not in order. The Department column.

EmployeeID is the primary key for the relation below. Which column violates a rule (characteristic) of a relation? Employee Relation EmployeeID Department PhoneNum PhoneNum 300 Finance 321-299-1234 407-999-2300 200 Sales 407-222-9090 321-365-0912 400 Sales 407-807-1124 407-453-2294 100 HR 321-934-2034 Group of answer choices The column named PhoneNum because you can’t have two columns with the same name. All the columns are valid. The EmployeeID column because the ID numbers are not in order. The Department column.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter4: Constraints

Section: Chapter Questions

Problem 1RQ: What is the difference between a PRIMARY KEY constraint and a UNIQUE constraint?

See similar textbooks

EmployeeID	Department	PhoneNum	PhoneNum
300	Finance	321-299-1234	407-999-2300
200	Sales	407-222-9090	321-365-0912
400	Sales	407-807-1124	407-453-2294
100	HR		321-934-2034

Similar questions

ProductID is the primary key column for the relation below. Which row violates a rule (characteristic) of a relation? Product Relation ProductID Name Cost 100 Hammer 19.99 300 20 pack washers 6.75 200 Tape 3.19 400 1 gal paint 24.99 Group of answer choices The row for ProductID = 300 because it is out of order. The rows need to be in order by ProductID. None of the rows are valid. All the rows are valid. The row for ProductID = 400 because it is out of order. The rows need to be in order of cost.
Each relationship is mapped into a relation? true or false
ProductID is the primary key column for the relation below. Which column violates a rule (characteristic) of a relation? Product Relation Name Cost ProductID Hammer 19.99 100 20 pack washers 6.75 200 Tape 3.19 300 1 gal paint 24.99 400 Group of answer choices The Cost column because it is out of order. The columns must be in alphabetical order. All the columns are valid. None of the columns are valid. The ProductID column. It is the primary key column and must be first.
The properties of the relation object can be used to implement the master-detail functionality which most appropriate for your application. You can delete a master-detail relation by selecting it in the Object Navigator and choosing Navigator => Delete. Discuss the Deletion of Relations in detail.
Identify if the following relation is in 1NF: STUDENT(StudentID, FirstName, LastName, (CourseID, CourseName, CourseLocation))
Which of the following is the term for a cell in a relation that has no data? Group of answer choices blank value spaces empty value null value
After setting up all relations, you need to apply following queries to get data from given relations: (Write queries and also paste screenshots in answer file) Get all employees data who are older than ‘Jones’ in company. (Hint: Older employees are those whom hire date is less than others)Get sum of salaries of all ‘Boston’ employees.Get all employees who take grade 1 or grade 3 salary. Using oracle APEX we are creating a table now - CREATE TABLE DEPT( DEPTNO NUMBER(10) NOT NULL, DNAME VARCHAR(50) NOT NULL, LOC VARCHAR2(30), CONSTRAINT DEPT_PK PRIMARY KEY (DEPTNO) ); We use NOT NULL constraint to make the cell occupied with something related to column line for example; we can see a lot of applications where we see (field is mandatory) Step 2 NOW EMP TABLE- CREATE TABLE EMP( EMPNO NUMBER(10)NOT NULL, ENAME VARCHAR2(50)NOT NULL, JOB VARCHAR2(50), MGR VARCHAR2(50), HIREDATE DATE, SAL NUMBER(6), COMM VARCHAR2(50) DEPTNO NUMBER(5)NOT NULL, CONSTRAINT EMP_FK FOREIGN KEY(…
Primary key identifies a unique tuple of a relation, true or false?
After setting up all relations, you need to apply following queries to get data from givenrelations: (Write queries and also paste screenshots in answer file) Get all the employees work with ‘Martin’ or ‘Scott’ in their departments. Get all employees work under management of ‘Blake’. Sort in descending order withrespect to employee number. Get all employees with letter ‘A’ in their name, who work in New York.Get all employees data whom salaries are more than combined salaries of Adams andSmith. Using oracle APEX we are creating a table now - CREATE TABLE DEPT( DEPTNO NUMBER(10) NOT NULL, DNAME VARCHAR(50) NOT NULL, LOC VARCHAR2(30), CONSTRAINT DEPT_PK PRIMARY KEY (DEPTNO) ); We use NOT NULL constraint to make the cell occupied with something related to column line for example; we can see a lot of applications where we see (field is mandatory) Step 2 NOW EMP TABLE- CREATE TABLE EMP( EMPNO NUMBER(10)NOT NULL, ENAME VARCHAR2(50)NOT NULL, JOB VARCHAR2(50), MGR VARCHAR2(50),…
The table STUDENT has the attributes STUDENT_ID, NAME, SCHOOL_ID, and ADDR. The table SCHOOL has the attributes SCHOOL_ID, NAME, and STATE_CODE. Assume that there is a 1:N relation between SCHOOL and STUDENT. Which of the following creates a table that shows the STUDENT attributes and the corresponding SCHOOL attributes? a. SELECT * SCHOOL_ID FROM STUDENT JOIN SCHOOL b. SELECT * SCHOOL_ID FROM STUDENT JOIN SCHOOL USING(SCHOOL_ID) c. SELECT * SCHOOL_ID FROM STUDENT NATURAL JOIN SCHOOL d. SELECT * SCHOOL_ID FROM STUDENT, SCHOOL WHERE SCHOOL_ID = SCHOOL_ID
Given the following relation that stores details about students' activities: StudentID StudentName Activity ActivityFee AmountPaid 100 Jones Golf 65.00 65.00 100 Jones Skiing 200.00 0.00 200 Davis Skiing 200.00 0.00 200 Davis Swimming 50.00 50.00 300 Garrett Skiing 200.00 100.00 300 Garrett Swimming 50.00 50.00 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00
Assume a user creates a new relation r1 with a foreign key pointing to another relation r2. What level of authorization is required for the user on r2? Why should this not be permitted without permission?