Other
Click here if you need help with assignment answers
- Course
- Institution
Get help with Assginment 1 answers for ICT. It will help with preparation for the exam.
[Show more]
Seller
Follow
koketjondimande
Reviews received
Content preview
ICT3621 DATABASE DESIGN ASSIGNMENT 1Composite and Simple Attributes
1. is key attribute that can be further subdivided
to yield additional attributes.
The correct answer is:
[Composite and Simple Attributes] is key attribute that can be further
subdivided to yield additional attributes.
2. One or more attributes that determine other attributes.
a. Key
b. Superkey
c. Primary key
d. Composite key
The correct answer is:
Key
Unary relationship
3. is the association is maintained within a single entity.
The correct answer is:
[Unary relationship] is the association is maintained within a single entity.
Ternary relationship
4. exists when three entities are associated.
The correct answer is:
[Ternary relationship] exists when three entities are associated.
Optional participation
5. is one entity occurrence does not require a
corresponding entity occurrence in a particular relationship.
The correct answer is:
[Optional participation] is one entity occurrence does not require a corresponding
entity occurrence in a particular relationship.
6. It indicates the number of entities or participants associated with a relationship.
a. Urinary relationship
b. Relationship degree
c. Binary relationship
d. Ternary relationship
, The correct answer is:
Relationship degree
7. What is information?
a. Raw facts that have not been processed to reveal any meaning to the
primary user.
b. The result of processing raw data to reveal its meaning.
c. Information consists of transformed data and facilitates decision making.
d. The result of processing raw data to reveal its meaning. Information
consists of transformed data and facilitates decision making.
The correct answer is:
The result of processing raw data to reveal its meaning. Information consists of
transformed data and facilitates decision making.
optional attribute
8. An is an attribute that does not require a value. This
attribute can be left empty or have null value.
The correct answer is:
An [optional attribute] is an attribute that does not require a value. This attribute
can be left empty or have null value.
Identifiers
9. one or more attributes that uniquely identify each entity
instance.
The correct answer is:
[Identifiers] one or more attributes that uniquely identify each entity instance.
10. What is query result set?
a. A condition in which different versions of the same data yield different results.
b. The collection of data rows returned by a query.
c. A task asked by the end user of a database in the form of SQL code. A
specific request for data manipulation issued by the end user or the application of
the DBMS.
d. A "spur-of-moment" question
The correct answer is:
The collection of data rows returned by a query.
11. What is data management?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller koketjondimande. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $6.90. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
52355 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now