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));
brief history,definition,current trends and future trends if any of data fragmentation
Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie
Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente
Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on
What are the ways in which the variable-length records arise in database systems? Storage of many record types in a file. Record types that permit variable lengths for one o
external view of DBMS in healthcare department?
WHAT IS MEANT BY E-R MODEL
External failure : A failure can also result because of an external cause, such as earthquakes, fire, floods, etc. The database must be duly backed up to avoid troubles occurring d
Define Serializable schedule Serializable schedule: An interleaved schedule of much more than one transaction is known as a serializable schedule, if it is equal to some serial
give some example real life situation where DBMS are most suitable
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd