Hrm 531 Week 1 Term Paper

2742 Words11 Pages
Week 1 Read Chapter 1 to discuss the following: 1. Briefly outline your understanding of concepts of DBMS with suitable examples to help understand your fellow class-members. 2. Explain with simple examples the following: a. Data independence & Structural independence. b. Data redundancy 3. From your reading, discuss different types of databases? Discuss briefly the type of database that is being used at your work and also the type of operating system used. 4.What is metadata and its importance? Using UMUC Library resources, research on metadata and provide some examples on the topic. Make sure to post links for your findings to assist and benefit class-members to better understand this important topic. 5. Compare and contrast unstructured…show more content…
Normalization is again a simple (if understood) process else this could be the most complicated process resulting in redundancies in your design process. You should also understand that normalization will not fix all design issues but offers to guide you to create a good design for your table structures. A good example could be that Normalization cannot detect the presence of synonyms. To summarize, normalization will help you to standardize the process of creating good tables and prevent…show more content…
Chapter 9 from Database Systems Text Book (Coronel, Morris & Rob). 2. Practice concepts from chapters 7, 10 & 11 from Oracle SQL by Example (Rischert). Assignment: • Apply suggested fixes to Lab Part 3. Communicate with Professor/TA if no communication or comments received for Lab submissions. Resubmit Lab Part 3 to respective assignment folder. • Submit Lab Part 4 (Queries) to Lab Part 4 assignment folder. • Research Paper due next week. Practice SQL on NOVA/ISQLPLUS Do not hesitate to seek assistance of TA or me for your lab project as we are nearing the closure. Weekly Discussion: 1. Using UMUC Library Resources, locate a good reference about SDLC methodologies and discuss briefly how it can help database development. 2. Based upon your skills developed and practice of SQL develop 5 challenging scripts, execute, capture output and post the following into the conference: a. SQL Script b. Output c. Explain what the script does. Note: There will be extensive coverage for SQL for the final exam. This exercise is intended to prepare you for the final exam, hence your script should be able to demonstrate your understanding of reading material illustrated in Oracle SQL by Example book in addition to readings from the text book. Avoid writing simple SQL, focus on complex joins, sub queries and nested joins. (Nested or co-related sub

More about Hrm 531 Week 1 Term Paper

Open Document