1. List five disadvantages of file processing systems.
2. List the nine major components in a database system environment.
3. In which of the five phases of the SDLC do database development activities occur?
4. State two conditions that indicate when a database designer should consider using supertype/subtype relationships.
5. Give an example (other than those discussed in the chapter) of a supertype/subtype relationship.
6. In what ways is starting a data modeling project with a packaged data model different from starting a data modeling project with a clean sheet of paper?
7. Summarize six important properties of relations.
8. Explain in your own words what the precision (p) and scale (s) parameters for the Oracle data type NUMBER mean.
9. Suppose you are designing a default value for the age field in a student record at your university. What possible values would you consider, and why? How might the default vary by other characteristics of the student, such as school within the university or degree sought?
10. When a student has not chosen a major at a university, the university often enters a value of "Undecided" for the major field. Is "Undecided" a way to represent the null value? Should it be used as a default value? Justify your answer carefully.
11. What are SQL-92, SQL:1999, and SQL:200n? Briefly describe how SQL:200n differs from SQL:1999.
12. Describe a relational DBMS (RDBMS), its underlying data model, its data storage structures, and how data relationships are established.
13. List six potential benefits of achieving an SQL standard that is widely accepted.
14. When is an outer join used instead of a natural join?
15. What is the purpose of the COMMIT command in SQL? How does commit relate to the notion of a business transaction (e.g., entering a customer order or issuing a customer invoice)?
16. Explain the structure of a module of code that defines a trigger.
17. Can an outer join be easily implemented when joining more than two tables? Why or why not?
18. This chapter discusses the data dictionary views for Oracle 11g. Research another RDBMS, such as Microsoft SQL Server, and report on its data dictionary facility and how it compares with Oracle.
Course
:
Database and Information Management
·
Please use
APA format only
·
Answer all the questions and provide citations where ever required
·
Plagiarism free document
·
Answer all questions accordingly.
·
Please turn it in on time
1.
List five disadvantages of file processing systems.
2.
List the nine major components in a database system environment.
3.
In which of the five phases of the SDLC do database development activities
occur?
4.
State two conditions that indicate
when a database designer should consider
using supertype/subtype relationships.
5.
Give an example (other than those discussed in the chapter) of a
supertype/subtype relationship.
6.
In
what ways is starting a data modeling pro
ject with a packaged data model
different
from starting a data modeling project with a clean sheet of paper?
7.
Summarize six important properties of relations.
8.
Explain in your own words what the precision (p) and scale (s) parameters for
the Oracle data type NUMBER mean.
9.
Suppose you are desi
gning a default value for the age field in a student
record at your university.
What possible values would you consider, and
why? How might the default vary by other characteristics of the student, such
as school within the university or degree sought?
10.
Wh
en a student has not chosen a major at a university, the university often
enters a value of "Undecided" for the major field.
Is "Undecided" a way to
represent the null value? Should it be used as a default value? Justify your
answer carefully.
11.
What are
SQL
-
92, SQL:1999, and SQL:200n? Briefly describe how
SQL:200n
differs from SQL:1999.
12.
Describe a relational DBMS (RDBMS), its underlying data model, its data
storage structures, and how data relationships are
established.
13.
List six potential benefits of achieving an SQL standard that is
widely
accepted.
14.
When is an outer join used
instead of a natural join?
15.
What is the purpose of
the COMMIT command in SQL? How does commit
relate to the notion of a business
transac
tion (e.g., entering a customer order
or issuing a customer invoice)?
16.
Explain the structure of
a module of code that defines a trigger.
17.
Can an outer join be easily implemented when joining more than two tables?
Why or why not?
Course: Database and Information Management
Please use APA format only
Answer all the questions and provide citations where ever required
Plagiarism free document
Answer all questions accordingly.
Please turn it in on time
1. List five disadvantages of file processing systems.
2. List the nine major components in a database system environment.
3. In which of the five phases of the SDLC do database development activities
occur?
4. State two conditions that indicate when a database designer should consider
using supertype/subtype relationships.
5. Give an example (other than those discussed in the chapter) of a
supertype/subtype relationship.
6. In what ways is starting a data modeling project with a packaged data model
different from starting a data modeling project with a clean sheet of paper?
7. Summarize six important properties of relations.
8. Explain in your own words what the precision (p) and scale (s) parameters for
the Oracle data type NUMBER mean.
9. Suppose you are designing a default value for the age field in a student
record at your university. What possible values would you consider, and
why? How might the default vary by other characteristics of the student, such
as school within the university or degree sought?
10. When a student has not chosen a major at a university, the university often
enters a value of "Undecided" for the major field. Is "Undecided" a way to
represent the null value? Should it be used as a default value? Justify your
answer carefully.
11. What are SQL-92, SQL:1999, and SQL:200n? Briefly describe how SQL:200n
differs from SQL:1999.
12. Describe a relational DBMS (RDBMS), its underlying data model, its data
storage structures, and how data relationships are established.
13. List six potential benefits of achieving an SQL standard that is widely
accepted.
14. When is an outer join used instead of a natural join?
15. What is the purpose of the COMMIT command in SQL? How does commit
relate to the notion of a business transaction (e.g., entering a customer order
or issuing a customer invoice)?
16. Explain the structure of a module of code that defines a trigger.
17. Can an outer join be easily implemented when joining more than two tables?
Why or why not?
gotham97
830-1.docx
0
