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!
In an organisation various projects are undertaken. Each projects can employ one or more employees. Every employee can work on one or more projects. Each project is undertaken on the request of client. A client can request for various projects. Each project has only one client. A project could use a number of items and a item may be used through various projects. Draw an E-R diagram and convert it to a relational schema.
The relational schema has subsequent tables 1) Project (Pid, Pname) 2) Employee (Empid, Ename) 3) Client (Cno, Cname) 4) Item (I type, I name) 5) Use (Pid, I type) 6) Work (Pid, Empid) 7) Request (Pid, Cno)
List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view. Ans: The two restrictions are: 1. If a view
What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)
Boyce-Code Normal Form (BCNF) A relationship is said to be in BCNF if it is already in 3NF and the left hand side of each dependency is a candidate key. A relation who is in 3N
Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.
WHAT IS MEANT BY E-R MODEL
Explain the term - Handling Boundary Condition These are some circumstances that to be handled in any system initialization and termination. Describes how system is bro
What is the initial step for object-oriented designing The initial step for object-oriented designing is object modeling. Before we go into deep about object modeling first of
Explain Candidate key? Candidate Key - A candidate key is a minimal superkey, that can be used to uniquely identify a tuple in the relation.
List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation
Database Manager It is the interface among low-level data, queries and application programs. Databases typically need a large amount of storage space. It is kept on disks, as
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