What are the seven major collaborative technologies? What feature or features does each technology offer for communication and productivity? Collaborative Technology Features Email Has the SMTP server which adds date and time information, and then directs the message to the …
What are three categories that describe the nature of information resources? Give an example of each. How do you characterize the relationships within each category of information? Structured information: A sales transaction with clearly defined fields for date, customer …
Three categories that describe the nature of information resources Read more »
FINAL EXAM Instructions: Articles Summarization from msdn.com: Visit msdn.microsoft.comand search for “SQL Server Security Guidelines.” Read articles at three of the links that you find and summarize them Use Google (google.com) or another search engine and search the Web for “Database …
Quiz 3 Create an example of a table that is in first normal form, but not in second normal form. Student ID Name Prof_ID Prof_name Grade 001 Mark 2 Benzo 6 002 Henry 3 Schmid 4 003 Tobler 1 Borner …
Create an example of a table that is in first normal form Read more »
Purpose of Database Instructions: What is the purpose of a database, and how does the database accomplish this purpose? What are the components of a database system? What are the characteristics of relationships, normalization, and keys and dependencies? Abstract Database …
Case Study: Next Generation Identification Database Lockheed Martin, IBM, Accenture are among those private contractors that are helping develop and implement NGI. What privacy concerns does their involvement in the project raise? The main concern in this case is the …
Summarize the DBA’s responsibilities for managing database structure. The responsibilities of a Database Administrator fall into two categories: Development Category: The DBA creates staff DBA function and decides the DBA group. Other responsibility is to form a steering committee and …
ummarize the DBA’s responsibilities for managing database structure. Read more »
Describe why database redesign is necessary? Database redesign involves the redesign of an existing database to make room for required changes or to make other improvements to the database performance. There is no guarantee that a database will be 100% …
What is an SQL view? What purposes do views serve? SQL view is utilized for simplification of complex joins that are used repeatedly across an SQL database. These views can be huge time savers by grouping frequently used tables in …
What is an SQL view? What purposes do views serve? Read more »
Describe two disadvantages of surrogate keys. Explain why they are disadvantages. Surrogate keys has many advantages and disadvantages. Advantages: Surrogate keys are fixed and are unique within the table they are located. When the row that the key is associated …
Describe two disadvantages of surrogate keys. Explain why they are disadvantages. Read more »