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)
Ask question #Minim 100 words accepted#what is recovery management component in database management system and how it is useful
What is a primary key? Primary key is chosen by the database designer as the principal means of identifying an entity in the entity set.
What is Identity? Identity (or AutoNumber) is a column that automatically produces numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID
What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be
In an E-R diagram an entity set is represent by? In an E-R digram entity set is represted by rectangle.
What are the advantages of Logical Databases? It offers a simple-to-use selection screens. You can change the pre-generated selection screen to your needs. It offers check f
What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it
What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a
Haw does it work one database application
Three Level Architecture of DBMS or Logical DBMS Architecture The logical architecture defines how data in the database is perceived by users. It is not deals with how the da
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