Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Create table employee and enter employee data in SQL?
Consider the following relational schemas: EMPLOYEE (EMPLOYEE_NAME, STREET, CITY) WORKS (EMPLOYEE_NAME, COMPANYNAME, SALARY) COMPANY (COMPANY_NAME, CITY) Specify the table definitions in SQL.
Ans. CREATE TABLE EMPLOYEE( EMPLOYEE_NAME VARCHAR2(20) PRIMARY KEY,STREET VARCHAR2(20),CITY VARCHAR2(15));CREATE TABLE COMPANY( COMPANY_NAME VARCHAR2(50) PRIMARY KEY,CITY VARCHAR2(15));CREATE TABLE WORKS( EMPLOYEE_NAME VARCHAR2(20)REFERENCES EMPLOYEE(EMPLOYEE_NAME,COMPANYNAME VARCHAR2(50)REFERENCES COMPANY(COMPANY_NAME,SALARY NUMBER(6),CONSTRAINT WORKS_PK PRIMARY KEY(EMPLOYEE_NAME, COMPANY_NAME));
The Proliferation of Object-Oriented Methods The first few years of the 1990s saw blossoming of around fifty various object oriented methods. This proliferation is a sign of g
What are the several forms of identity? a) Value b) Name c) Built-in
What is called as an N-way merge? The merge operation is a generalization of the two-way merge used by the standard in-memory sort-merge algorithm. It merges N runs, so it is k
List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti
1. Create a subroutine that does the remote blast on the file protein.fa. 2. Pass that returned files from the blast to another subroutine that parses the output and sends it to
How can you map NULL values to other values while display? IF( ) , IFNULL( ) keywords are used to do so. They are 'LIMIT' is used for the following kinds of problems: 1) Ans
Submit SQL INSERT Statements that will populate the database with sample data. You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement
What are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s
For problems 1-4, give all candidate keys for the tables with FDs specified. Composite candidate keys must be put in parentheses, and candidate keys must be separated with commas
What is the use of rename operation? Rename operation is used to rename both relations and an attributes. It uses the as clause, taking the form: Old-name as new-name.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd