MMIS-580 - Database Systems Syllabus
33 Pages

MMIS-580 - Database Systems Syllabus

Course Number: MMIS 580, Spring 2012

College/University: Friends University

Word Count: 4673

Rating:

Document Preview

Online Graduate School MMIS 580 Database Systems Syllabus Course Editor Dr. Jason Ferguson Program Director 2011 Friends University 1 of 33 Course Description MMIS 580 Database Systems This course focuses around the core skills of identifying organizational information requirements, modeling them using conceptual data modeling techniques, converting the conceptual data model into relational data models...

Unformatted Document Excerpt
Coursehero >> Kansas >> Friends University >> MMIS 580

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

School MMIS Online Graduate 580 Database Systems Syllabus Course Editor Dr. Jason Ferguson Program Director 2011 Friends University 1 of 33 Course Description MMIS 580 Database Systems This course focuses around the core skills of identifying organizational information requirements, modeling them using conceptual data modeling techniques, converting the conceptual data model into relational data models and verifying its structural characteristics with normalization techniques, and implementing and utilizing a relational database using an industry-strength database management system. Techniques for managing the design and development of database systems, to include fundamentals of database architecture and database applications are also covered. One component of this course requires the student to plan, design, and implement a database application. Friends University Catalog - MMIS Program Overview Topical Outline Introduction to Database Environments Understanding Relational Databases Data Modeling Relational Database Design Application Development with Relational databases Managing Database Environments Course Outcomes Students will develop technical knowledge of the concepts, principles, issues, and techniques for managing data resources through research activities and practical application. Upon completion of this course, students will be able to: 1. Explain the role of databases and database management systems in managing organizational data and information. 2. Examine the history of data management systems. 3. Compare database architectures. 4. Articulate database management technologies. 5. Create a database application to solve a business problem. 6. Use at least one conceptual data modeling technique (such as entity-relationship modeling) to capture the information for an enterprise domain. 7. Describe the purpose and principals of normalizing a relational database structure. 8. Compare key principles of data security and identify data security risk and violations in data management system design. 2011 Friends University 2 of 33 Course Policies Online Participation Participation online is expected throughout the course. Content areas may include discussions, written assignments, design components, project development, etc. Each course will be different depending on the assignments required. A class week is defined as seven days; Monday through Sunday All official university communication will be through your Friends University issued email account. Attendance Policy Weekly attendance is determined by activity during weekly sessions. A student is reported absent for a weekly session if they do not participate in activities during that week. Contact your instructor if you cannot participate in a weekly session. Excessive absences negatively influence grades and can result in course failure. Catalog Links ADA Student Services http://catalog.friends.edu/content.php?catoid=4&navoid=172#disa_serv Student Conduct http://catalog.friends.edu/content.php?catoid=4&navoid=172#stud_cond_code Academic Honesty & Honor Code http://catalog.friends.edu/content.php?catoid=4&navoid=172#acad_hono_code Friends University Library Edmund Stanley Library, named after the Universitys first president, is committed to collecting the resources you need for your coursework and to helping you use those resources. The library has books, journals, magazines, newspapers, and media (CDs, DVDs, etc.) and provides access to the full text of articles through online databases. Go to the Librarys Tutorial Web page http://library.friends.edu/Tutorials.html where you will find a variety of instructional materials designed to acquaint you with the Librarys resources and services. Listed under the first header Library Orientation for DCP (Degree Completion Program) and GRAD (Graduate) Programs on the Tutorials page is a link to recommendations about the short videos, tutorials, and handouts that are pertinent to your program. Please contact the Library at 316-295-5880 (toll free 800-794-6945 x5880) or askmax@friends.edu if you have questions or comments. 2011 Friends University 3 of 33 To navigate from the Friends University homepage http://www.friends.edu to the Librarys Tutorial Web page follow these steps: 1) Click on Library on the lower right of the Universitys homepage. 2) Click on Catalog and Databases on the left. This takes you to FriendLiCat, the Librarys online catalog. 3) In the Library Info area on the right side where several links are listed, click on Tutorials. Course Materials Required Text: Coronel, Morris, Rob (2010). Database Systems: Design, Implementation and Management, 9th ed. Course Technology. ISBN: 978-0-538-46968-5 E-book & Rental information available at: Cengagebrain.com Chapter presentations, quizzes, and other useful information available at the publisher site: www.cengage.com Recommended: Student membership in a computer-related professional organization: ACM (Association for Computing Machinery) http://www.acm.org/. ACM Professional Development Center & Electronic Books Online http://pd.acm.org Other Sources: MSDNAA http://msdn04.e-academy.com/elms/Storefront/Home.aspx?campus=friends_cbi username: your Friends University email address password: assigned by MSDNAA, sent to you via email Design Tools: Visio Databases: Microsoft Access, SQL Server Integrated Development Environment: Visual Studio General Database Resources Database: The student may use any version of Microsoft SQL Server but the preferred version is SQL Express 2008. Students can download SQL Express 2008 free of charge from the MSDNAA site: http://msdn04.eacademy.com/elms/Storefront/Home.aspx?campus=friends_cbi. The focus of this course is database design and application development, it is not a tutorial on using a specific database product. Students are expected to learn to use the database product independently. 2011 Friends University 4 of 33 Course Structure and Grades Course Policies Class Participation and Attendance Your attendance is required for all classes, and you must be prepared to participate in class activities. Attendance and class participation will count towards your grade for the course. All work must be submitted using an appropriate computer application. Hand-written or hand-drawn work will not be accepted for grade. If you find it necessary to be late for class or absent, please contact the professor by email message to this effect. It is the students responsibility to request make-up work for an absence. Academic Honesty Ethical behavior, honesty, and integrity are expected from all students. Please refer to the Academic Honesty Policy in the Friends University Catalog of Courses. Assignments To receive full credit, all work must be submitted. Group activities are due during the class period in which the assignment is made. The instructor reserves the right to assess partial credit for assignments that do not meet the criterion specified for that assignment. Grading Policy Method of Evaluation Number 20 1 1 1 1 1 1 1 1 8 Online Postings (discussion or wiki) Assignment 1 Assignment 2 Assignment 3 Assignment 4 Assignment 5 Assignment 6 Assignment 7 Assignment 8 Quizzes Total 2011 Friends University @ @ @ @ @ @ @ @ @ @ Points 5 20 30 60 20 30 75 30 30 20-30 Total 100 20 30 60 20 30 75 30 30 170 565 5 of 33 Grades Letter grades are determined by the following scale: A = 90% to 100% B = 80% to 89% C = 70% to 79% 2011 Friends University 6 of 33 Week One Introduction to Database Development Data Models Objectives Provide an introduction to database technologies and their impact on organizations. Provide an overview of the database development process. Examine data modeling and why database models are important. Assignments Read Chapters 1 & 2 Presentations: Review chapter 1 presentation Review chapter 2 presentation Quizzes: Chapter 1 - Multiple choice & essay Chapter 2 - Multiple choice & essay Discussion Topic One: Explain why database design is so important. Cite some specific database design examples (good and bad) that you have observed and/or experienced. Discussion Topic Two: Does the existence of a DBMS guarantee good data management, and correct and timely information? Discussion Topic Three: Although the database system yields considerable advantages over earlier data management approaches, database systems do impose costs. List and describe at least two potential costs of implementing a database system. Discussion Topic Four: Provide a few examples to compare and contrast unstructured and structured data. Which type is more prevalent in a typical business environment? 2011 Friends University 7 of 33 Assignments Given the file structure shown, answer the following questions: 1. What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure? 2. If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure? 3. What data redundancies do you detect? How could those redundancies lead to anomalies? 4. Given the table structure shown, write the business rule(s) that govern the relationship between AGENT and CUSTOMERS. 2011 Friends University 8 of 33 Week Two The Relational Data Model Entity Relationship Modeling Objectives Provide a foundation for using relational databases. Provide a foundation of entity relationship components. Specify how relationships between entities are defined, refined, and incorporated into the database deisn process. Assignments Read Chapters 3 & 4 Presentations: Review chapter 3 presentation Review chapter 4 presentation Quizzes: Chapter 3 - Multiple choice & essay Chapter 4 - Multiple choice & essay Discussion Topic: Discussion Topic Five: Describe a database that you us at work or as a consumer. In general terms, describe its purpose, primary entities and relationships that you believe the database contains. Discussion Topic Six: Using the STUDENT and PROFESSOR tables shown, illustrate the difference between a natural join, an equijoin, and an outer join. Note: You can use Microsoft Excel to create the solutions. If you dont understand parts of the problem use this forum to ask questions of your classmates. Discussion Topic Seven: What role does the ER diagram play in the design process? 2011 Friends University 9 of 33 Assignments: Illustration for Problems 1-3 1. Using the illustration shown, create the table that results from applying a UNION relational operator to the tables. 2. Create the table that results from applying an INTERSECT relational operator to the tables. 3. Create the table that results from MACHINE DIFFERENCE BOOTH. 2011 Friends University 10 of 33 Illustration for Problems 4-8 The database is composed of four tables that reflect these relationships: An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEEs. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEEs. Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity. 4. For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 5. Create the ERD to show the relationship between EMPLOYEE and JOB. 6. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. 7. Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. 8. Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN. 9. Create an ERD based on the Crows Foot model, using the following requirements: An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices. 2011 Friends University 11 of 33 An INVOICE can include many detail lines (LINE), each of which describes one product bought by the customer. The product information is stored in a PRODUCT entity. The products vendor information is found in a VENDOR entity. Note: The ERD must reflect business rules that you are free to define (within reason). Make sure that your ERD reflects the conditions you require. 2011 Friends University 12 of 33 Week Three Advanced Data Modeling Objectives Explain the purpose of using entity relationship diagrams in the database development process. Create an entity relationship diagram (ERD) for a business application using a diagramming tool (Visio). Assignments Read Chapter 5 Presentations: Review chapter 5 presentation Quizzes: Chapter 5 - Multiple choice & essay Discussion Topic Eight: What primary key characteristics are considered desirable? Explain why each characteristic is considered desirable. Discussion Topic Nine: Under what circumstances are composite primary keys appropriate? If possible, provide an example of when it is appropriate to use a composite primary key. Discussion Topic Ten: When implementing a 1:1 relationship, where should you place the foreign key if one side is mandatory and one side is optional? Should the foreign key be optional or mandatory? Assignment: 10. Given the following business scenario, create a Crows Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents. 2011 Friends University 13 of 33 11. Given the following business scenario, create a Crows Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patients name and date of birth are recorded. Some patients are resident patients (they spend at least one night in the hospital) and others are outpatients (they are treated and released). Resident patients are assigned to a room. Each room is identified by a room number. The system also stores the room type (private or semiprivate), and room fee. Over time, each room will have many patients that stay in it. Each resident patient will stay in only one room. Every room must have had a patient, and every resident patient must have a room. 2011 Friends University 14 of 33 Week Four Normalization of Database Tables Objectives Use normalization techniques to control redundancy in relational tables. Assignments Read Chapter 6 Presentations: Review chapter 6 presentation Quizzes: Chapter 6 - Multiple choice & essay Discussion Topic Eleven: Discuss the practicality and feasibility of normalization beyond 3NF. Discussion Topic Twelve: Open discussion of creating ERDs and using Visio. If you have problems resolved, then share your ideas (not your work). If you are in need of assistance then ask, share your concerns. Discussion Topic Thirteen: Open discussion on Assignment 12 & 13. If you have problems resolved, then share your ideas (not your work). If you are in need of assistance then ask, share your concerns. Discussion Topic Fourteen: Why is using an ERD to develop good database design an iterative process. Assignment: 12. The dependency diagram in the following illustration indicates that a patient can receive many prescriptions for one or more medicines over time. Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table. 2011 Friends University 15 of 33 13. The dependency diagram in the following illustration indicates that authors are paid royalties for each book that they write a for publisher. The amount of the royalty can vary by author, by book, and by edition of the book. a. Based on the dependency diagram, create an appropriate dependency diagram of database tables that are at least in 2NF. b. Create a dependency diagram that represents the database tables in at least 3NF. 14. To keep track of office furniture, computers, printers, and so on, the FOUNDIT company uses the table structure shown in the following illustration. Attribute Name Sample Value Sample Value Sample Value ITEM_ID 231134-678 342245-225 254668-449 ITEM_LABEL HP DeskJet 895Cse HP Toner DT Scanner ROOM_NUMBER 325 325 123 BLDG_CODE NTC NTC CSF BLDG_NAME Nottooclear Nottoclear Canseefar BLDG_MANAGER I. B. Rightonit I. B. Rightonit May B. Next 2011 Friends University 16 of 33 a. Given that information, write the relational schema and draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies. b. Write the relational schemas and create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary. c. Draw the Crows Foot ERD. 2011 Friends University 17 of 33 Week Five Structured Query Language (SQL) Objectives Use SQL to create tables, indexes, and views. Use SQL to manipulate data (add, modify, delete, retrieve). Use SQL to query a database for usable information. Assignments Read Chapter 7 Presentations: Review chapter 7 presentation Quizzes: Chapter 7 - Multiple choice & essay Discussion Topic Fifteen: Open discussion on Assignments 15 - 45. If you have problems resolved, then share your ideas (not your work). If you are in need of assistance then ask, share your concerns. Assignment: 15. What type of integrity is enforced when a primary key is declared? 16. What are referential constraint actions? 17. What is the difference between an inner join and an outer join? 18. Given the structure and contents of the ConstructCo database shown in the following illustration, use SQL commands to answer Problems 19-45. 2011 Friends University 18 of 33 19. Write the SQL code that will create the table structure for a table named EMP_1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in the table below. (Note that the JOB_CODE is the FK to JOB.) 20. Having created the table structure in Problem 18a, write the SQL code to enter the first two rows for the table shown in the following illustration. EMP_1 Table 2011 Friends University 19 of 33 21. Assuming the data shown in the EMP_1 table have been entered, write the SQL code that will list all attributes for a job code of 502. 22. Write the SQL code that will save the changes made to the EMP_1 table. 23. Write the SQL code to change the job code to 501 for the person whose employee number (EMP_NUM) is 107. After you have completed the task, examine the results, and then reset the job code to its original value. 24. Write the SQL code to delete the row for the person named William Smithfield, who was hired on June 22, 2004, and whose job code classification is 500. (Hint: Use logical operators to include all of the information given in this problem.) 25. Write the SQL code that will restore the data to its original status; that is, the table should contain the data that existed before you made the changes in Problems 23 and 24. 26. TinyVideo is a small movie rental company with a single store. TinyVideo needs a database system to track the rental of movies to its members. TinyVideo can own several copies (VIDEO) of each movie (MOVIE). For example, the store may have 10 copies of the movie Twist in the Wind. Twist in the Wind would be one MOVIE and each copy would be a VIDEO. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime, therefore, there is a M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship. The complete ERD is provided in the following illustration. Write the SQL code to create the table structures for the entities shown above. The structures should contain the attributes specified in the ERD. Use data types that 2011 Friends University 20 of 33 would be appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD. 27. The following tables provide a very small portion of the data that will be kept in the database. This data needs to be inserted into the database for testing purposes. Write the INSERT commands necessary to place the following data in the tables that were created in problem 26. MEMBERSHIP Mem_ Mem_ Mem_ Mem_ Mem_Street Num Fname Mem_City Lname Mem_ Mem_Zip State Balance 102 Tami Dawson 2632 Takli Circle Norene TN 37136 11 103 Curt Knight 4025 Cornell Court Flatgap KY 41219 6 104 Jamal Melendez 788 East 145th Avenue Quebeck TN 38579 0 105 Iva Mcclain 6045 Musket Ball Circle Summit KY 42783 15 106 Miranda Parks 4469 Maxwell Place Germantown TN 38183 0 107 Rosario Elliott 7578 Danner Avenue Columbia TN 38402 5 108 Mattie Guy 4390 Evergreen Street Lily KY 40740 0 109 Clint Ochoa 1711 Elm Street Greeneville TN 37745 10 110 Lewis Rosales 4524 Southwind Circle Counce TN 38326 0 111 Stacy Mann 2789 East Cook Avenue Murfreesboro TN 37132 8 112 Luis Trujillo 7267 Melvin Avenue Heiskell TN 37754 3 113 Minnie Gonzales 6430 Vasili Drive Williston TN 38076 0 2011 Friends University 21 of 33 RENTAL Rent_Num Rent_Date Mem_Num 1001 01-MAR-09 103 1002 01-MAR-09 105 1003 02-MAR-09 102 1004 02-MAR-09 110 1005 02-MAR-09 111 1006 02-MAR-09 107 1007 02-MAR-09 104 1008 03-MAR-09 105 1009 03-MAR-09 111 DETAILRENTAL Rent_Num Vid_Num Detail_Fee Detail_Duedate Detail_Returndate Detail_Dailylatefee 1001 34342 2 04-MAR-09 02-MAR-09 1 1001 61353 2 04-MAR-09 03-MAR-09 1 1002 59237 3.5 04-MAR-09 04-MAR-09 3 1003 54325 3.5 04-MAR-09 09-MAR-09 3 1003 61369 2 06-MAR-09 09-MAR-09 1 1003 61388 0 06-MAR-09 09-MAR-09 1 1004 44392 3.5 05-MAR-09 07-MAR-09 3 1004 34367 3.5 05-MAR-09 07-MAR-09 3 2011 Friends University 22 of 33 1004 34341 2 07-MAR-09 07-MAR-09 1 1005 34342 2 07-MAR-09 05-MAR-09 1 1005 44397 3.5 05-MAR-09 05-MAR-09 3 1006 34366 3.5 05-MAR-09 04-MAR-09 3 1006 61367 2 07-MAR-09 1 1007 34368 3.5 05-MAR-09 3 1008 34369 3.5 05-MAR-09 1009 54324 3.5 05-MAR-09 1001 34366 3.5 04-MAR-09 05-MAR-09 3 3 02-MAR-09 3 VIDEO Vid_Num Vid_Indate Movie_Num 54321 18-JUN-08 1234 54324 18-JUN-08 1234 54325 18-JUN-08 1234 34341 22-JAN-07 1235 34342 22-JAN-07 1235 34366 02-MAR-09 1236 34367 02-MAR-09 1236 34368 02-MAR-09 1236 34369 02-MAR-09 1236 44392 21-OCT-08 1237 2011 Friends University 23 of 33 44397 21-OCT-08 1237 59237 14-FEB-09 1237 61388 25-JAN-07 1239 61353 28-JAN-06 1245 61354 28-JAN-06 1245 61367 30-JUL-08 1246 61369 30-JUL-08 1246 MOVIE Movie_Num Movie_Name Movie_Year Movie_Cost Movie_Genre Price_Code 1234 The Cesar Family Christmas 2007 39.95 FAMILY 2 1235 Smokey Mountain Wildlife 2004 59.95 ACTION 1 1236 Richard Goodhope 2008 59.95 DRAMA 2 1237 Beatnik Fever 2007 29.95 COMEDY 2 1238 Constant Companion 2008 89.95 DRAMA 2 1239 Where Hope Dies 1998 25.49 DRAMA 3 1245 Time to Burn 2005 45.49 ACTION 1 1246 What He Doesn't Know 2006 58.29 COMEDY 1 PRICE Price_Code Price_Description Price_Rentfee Price_Dailylatefee 1 Standard 2 1 2011 Friends University 24 of 33 2 New Release 3.5 3 3 Discount 1.5 1 1 .5 4 Weekly Special 28. Write the SQL command to save the rows inserted in Problem 27. 29. Write the SQL command to change the movie year for movie number 1245 to 2006. 30. Write the SQL command to change the price code for all Action movies to price code 3. 31. Write a single SQL command to increase all price rental fee values by $0.50. 32. Write the SQL command to save the changes made to the PRICE and MOVIE tables in Problems 29 31. 33. Write a query to display the movie title, movie year, and movie genre for all movies (result shown in the following illustration). 34. Write a query to display the movie year, movie title, and movie cost sorted by movie year in descending order (result shown in the following illustration). 35. Write a query to display the movie number, movie title, and price code for all movies with a title that starts with the letter R (result shown in the following illustration). 2011 Friends University 25 of 33 36. Write a query to display the movie title, movie year, and movie cost for all movies that contain the word hope anywhere in the title. Sort the results in ascending order by title (result shown in the following illustration). 37. Write a query to display the movie number, movie title, and movie cost for all movies with a cost greater than $40. 38. Write a query to display the movie number, movie title, movie cost, and movie genre for all movies that are either action or comedy movies and that have a cost that is less than $50. Sort the results in ascending order by genre. 39. Write a query to display the movie genre and the number of movies in each genre (result shown in the following illustration). 40. Write a query to display the average cost of all of the movies (result shown in the following illustration). 41. Write a query to display the movie genre and average cost of movies in each genre. 42. Write a query to display the movie genre and average price rental fee for movies in each genre that have a price (result shown in the following illustration). 43. Write a query to display the movie title, movie year, and movie cost for all movies that have a cost between $44.99 and $49.99 44. Write a query to display the movie title, movie year, price description, and price rental fee for all movies that are in the genres Family, Comedy, or Drama. 2011 Friends University 26 of 33 45. Write a query to display the rental number, rental date, movie title, and detail fee for each movie that was returned on or before the due date (result shown in the following illustration). 2011 Friends University 27 of 33 Week Six Advanced Query Formulation with SQL Objectives Use joins, nesting, and aggregate functions in SQL. Describe the concepts for using views. Create and use triggers and stored procedures Assignments Read Chapters 8 Presentations: Review chapter 8 presentation Quizzes: Chapter 8 - Multiple choice & essay Discussion Topic Sixteen: What is a trigger, and what is its purpose? Give an example. Discussion Topic Seventeen: What is a stored procedure, and why is it particularly useful? Give an example. Assignment: 46. Create the tables. (Use the example shown in the following illustration to see what table names and attributes to use.) 2011 Friends University 28 of 33 47. Insert the data into the tables you created in Problem 46. 48. Write the query that will generate a combined list of customers (from tables CUSTOMER and CUSTOMER_2) that do not include the duplicate customer records. (Note that only the customer named Juan Ortega shows up in both customer tables.) 49. Write the query that will generate a combined list of customers to include the duplicate customer records. 50. Write the query that will show only the duplicate customer records. 51. Write the query that will generate only the records that are unique to the CUSTOMER_2 table. 52. Write the query to show the invoice number, the customer number, the customer name, the invoice date, and the invoice amount for all customers with a customer balance of $1,000 or more. 53. Write the query that will show the invoice number, the invoice amount, the average invoice amount, and the difference between the average invoice amount and the actual invoice amount. 54. Write the trigger to update the CUST_BALANCE in the CUSTOMER table when a new invoice record is entered. (Assume that the sale is a credit sale.) Test the trigger using the following new INVOICE record: 8005, 1001, 27-APR-10, 225.40 Name the trigger trg_updatecustbalance 2011 Friends University 29 of 33 55. Write a procedure to add a new customer to the CUSTOMER table. Use the following values in the new record: 1002, Rauthor, Peter, 0.00 Name the procedure prc_cust_add. Run a query to see if the record has been added. 2011 Friends University 30 of 33 Week Seven Database Design Objectives Achieving an information system of which the database is a part. Utilize the Systems Development Life Cycle (SDLC) and the Database Life Cycle (DLC) concepts in designing and implementing a database system. Assignments Read Chapter 9 Presentations: Review chapter 9 presentation Quizzes: Chapter 9 - Multiple choice & essay Discussion Topic Eighteen: What are business rules? Why are they important to a database designer? Discussion Topic Nineteen: What is the relationship between a database and an information system, and how does this relationship have a bearing on database design? Discussion Topic Twenty: What factors are important in a DBMS software selection (in your initial response only identify and describe 2 factors)? Assignment: 56. The ABC Car Service & Repair Centers are owned by the SILENT car dealer; ABC services and repairs only SILENT cars. Three ABC Car Service & Repair Centers provide service and repair for the entire state. Each of the three centers is independently managed and operated by a shop manager, a receptionist, and at least eight mechanics. Each center maintains a fully stocked parts Inventory. Each center also maintains a manual file system in which each cars maintenance history is kept: repairs made, parts used, costs, service dates, owner, and so on. Files are also kept to track inventory, purchasing, billing, employees hours, and payroll. 2011 Friends University 31 of 33 You have been contacted by the manager of one of the centers to design and implement a computerized system. Given the preceding information, do the following: a. Indicate the most appropriate sequence of activities by labeling each of the following steps in the correct order. (For example, if you think that Load the database. is the appropriate first step, label it 1.) ____ Normalize the conceptual model. ____ Obtain a general description of company operations. ____ Load the database. ____ Create a description of each system process. ____ Test the system. ____ Draw a data flow diagram and system flowcharts. ____ Create a conceptual model, using ER diagrams. ____ Create the application programs. ____ Interview the mechanics. ____ Create the file (table) structures. ____ Interview the shop manager. b. Describe the various modules that you believe the system should include. c. How will a data dictionary help you develop the system? Give examples. d. What general (system) recommendations might you make to the shop manager? (For example. if the system will be integrated, what modules will be integrated? What benefits would be derived from such an integrated system? Include several general recommendations.) e. What is the best approach to conceptual database design? Why? f. Name and describe at least four reports the system should have. Explain their use. Who will use those reports? 2011 Friends University 32 of 33 Week Eight Database Administration and Security Objectives Define what the database administrators managerial and technical roles are. Explore data security, database security, and the information security framework. Use database administration tools and strategies. Assignments Read Chapter 15 Presentations: Review chapter 15 presentation Quizzes: Chapter 15 - Multiple choice & essay Assignments Discussion Topic Twenty one: Define security and privacy. How are these two concepts related? Discussion Topic Twenty two: What special considerations must you take into account when contemplating the introduction of a DBMS into an organization? Discussion Topic Twenty three: Why and how are new technological advances in computers and databases changing the DBA's role? 2011 Friends University 33 of 33

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Friends University - MMIS - 580
Friends University - MMIS - 580
Friends University - MMIS - 580
1. Describe Specialization and Generalization:a. Specialization: Creating new subclasses from an existing class. If it turns out thatcertain attributes, associations, or methods only apply to some of the objects ofthe class, a subclass can be created.
Florida State College - FAD - 3220
Each post should be at least 100 words with accurate citations.Post #1: Pretend that you are designing your dream home for your late adulthood years. Whatspecific environmental features would you include to meet your needs as you age. (due byThursday,
Wisconsin - ECON - 2
Comparison of MLK Jr. and Malcolm XThe tone and mood of Martin Luther King Jr. and Malcolm X were very different. While Kingwas peaceful and non-violent, X was militant and aggressive. Martin Luther King Jr. inspiredpeople by giving them hope as this l
Liberty - BUSI - 600
BUSI 600Group Discussion Board Forum 2 Part 1The following items are taken from the textbook sectiontitled Discussions Questions>Making Research Decisions, "Bringing Research to Life" and "FromConcepts to Practice" located at the end of each chapter. P
McGill - ECON - 208
Chapter 1: Economic Issues and Concepts1.1 The Complexity of the Modern Economy Economy: a system in which scares resources are allocated among competinguses. Economies tend to be complex systems and scares resources include land,labour and machines (
McGill - ECON - 208
Chapter 2: Economic Theories, Data and Graphs2.1 Positive and Normative Advice Normative Statement advice that depends on a value judgment, it tells otherswhat they ought to do (as opposed to what actually is) Positive Statement do not involve value j
McGill - ECON - 208
Chapter 3: Demand, Supply, and Price3.1 DemandQuantity Demanded Quantity demanded the amount of a good or service that consumers want topurchase during some time period Quantity demanded is desired quantity amount that consumers want to purchase,it
McGill - ECON - 208
Chapter 4: Elasticity4.1 Price Elasticity of Demand Price elasticity of demand determines how much the equilibrium quantity andequilibrium price will change Demand is said to be elastic when quantity demanded is responsive to changes inprice When qu
McGill - ECON - 208
Chapter 5: Markets in Action5.1 The Interaction Among Markets A technological improvement in one industry would have effects in many othermarkets. No market or industry exists in isolation from the economys many othermarkets. Feedback when a change
McGill - ECON - 208
Chapter 6: Consumer Behaviour6.1 Marginal Utility and Consumer Choice Utility the satisfaction or well-being that a consumer receives from consumersome service or good Utility cannot be measured directly It is possible to construct a useful theory of
McGill - ECON - 208
Chapter 7: Consumers and Producers7.1 What Are Firms? Firms can be organized in any one of 6 different ways.1. Single Proprietorship has one owner-manager who is personallyresponsibly for all aspects of the business, including its debts.2. Ordinary P
McGill - ECON - 208
Chapter 8: Producers in the Long Run8.1 The Long Run: No Fixed Factors There are many ways to produce any given output in the long run because allfactors can be varied Firms in the long run must decided what type and how many plant and equipmentthey
Mohawk Valley Community College - MANAGEMENT - 12BBAD
CHAPTER 1: OPERATIONS AND PRODUCTIVITYTRUE/FALSE1. Some of the operations-related activities of Hard Rock Caf include designing meals and analyzingthem for ingredient cost and labor requirements.True (Global company profile, easy)2. The production pr
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDECONT - Departamento de ContabilidadeDECONTPLANO DE ENSINODisciplinaANLISE ECONMICA -FINANCEIRA DAS EMPRESAS ICdigoSC205Crditos04 (quatro)Carga Horria04 aulas tericasPr Requisito
UFPR - MANAGEMENT - 1
MINISTRIO DA EDUCAOUNIVERSIDADE FEDERAL DO PARANSetor de Cincias Sociais AplicadasCoordenao do Curso de AdministraoGRADE HORRIA PARA O 1 SEMESTRE LETIVO DE 2009CURSO DE ADMINISTRAO NOTURNO CDIGO 60ACURRCULO DE 2007CDIGO/TURMADISCIPLINAPR-REQUISIT
UFPR - MANAGEMENT - 1
MINISTRIO DA EDUCAOUNIVERSIDADE FEDERAL DO PARANSetor de Cincias Sociais AplicadasCoordenao do Curso de AdministraoGRADE HORRIA PARA O 1 SEMESTRE LETIVO DE 2009CURSO DE ADMINISTRAO NOTURNO CDIGO 60A CURRCULO DE 2002CDIGO/TURMA DISCIPLINAPR-REQUISIT
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: FUNDAMENTOS DA GESTO ORGANIZACIONALCDIGO: SA047SEMESTRAL ( X )ANUAL ( )C
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: EMPREENDEDORISMO E CRIAO DE NOVOS NEGCIOSCDIGO: SA049SEMESTRAL ( X )ANUAL
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: ADMINISTRAO DE SISTEMAS DE INFORMAOCDIGO: SA051SEMESTRAL ( X )ANUAL ( )C
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: ADMINISTRAO DE MARKETINGCDIGO: SA053SEMESTRAL ( X )ANUAL ( )CRDITOS: 4C
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: ESTRATGIAS DE PRODUOCDIGO: SA057SEMESTRAL ( X )ANUAL ( )CRDITOS: 3CARGA
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: GESTO DO CAPITAL CIRCULANTECDIGO: SA059SEMESTRAL ( X )ANUAL ( )CRDITO: 4
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: SISTEMAS DE PRODUOCDIGO: SA063SEMESTRAL ( X )ANUAL ( )CRDITOS: 3CARGA H
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: TICA NAS ORGANIZAESCDIGO: SA068SEMESTRAL ( X )ANUAL ( )CRDITOS: 4CARGA
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: PLANEJAMENTO E ESTRATGIA DE MARKETINGCDIGO: SA070SEMESTRAL ( X )ANUAL ( )
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: DECISO DE INVESTIMENTOCDIGO: SA071SEMESTRAL ( X )ANUAL ( )CRDITOS: 4CAR
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: ADMINISTRAO ESTRATGICACDIGO: SA072SEMESTRAL ( X )ANUAL ( )CRDITOS: 4CAR
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: ADMINISTRAO DE PROJETOSCDIGO: SA073SEMESTRAL ( X )ANUAL ( )CRDITOS: 3CA
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: COMPORTAMENTO ORGANIZACIONALCDIGO: SA074SEMESTRAL ( X )ANUAL ( )CRDITOS:
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: TPICOS ESPECIAIS DE ADMINISTRAO DE PESSOASCDIGO: SA079SEMESTRAL ( X )ANUA
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: TPICOS ESPECIAIS EM ANLISE ORGANIZACIONALCDIGO: SA082SEMESTRAL ( X )ANUAL
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: ORGANIZAO E PLANEJAMENTO DE RECURSOSHUMANOSCDIGO: SA095SEMESTRAL ( X )AN
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: FUNDAMENTOS DE MARKETINGCDIGO: SA096SEMESTRAL ( X )ANUAL ( )CRDITOS: 4C
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: PRINCPIOS DE FINANASCDIGO: SA097SEMESTRAL ( X )ANUAL ( )CRDITO: 4CARGA
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: REMUNERAO, CARREIRA E AVALIAO DEDESEMPENHO DE PESSOASCDIGO: SA099SEMESTRA
UFPR - MANAGEMENT - 1
UNIVERSIDADE FEDERAL DO PARANSETOR DE CINCIAS SOCIAIS APLICADASDEPARTAMENTO DE ADMINISTRAO GERAL E APLICADACOORDENAO DO CURSO DE ADMINISTRAOPROGRAMA DE DISCIPLINADISCIPLINA: RECRUTAMENTO, SELEO E DESENVOLVIMENTO DEPESSOASCDIGO: SA100SEMESTRAL ( X
Berkeley - UGBA - 120B
MicroDrive Inc: December 31 Balance Sheet (Millions of Dollars)AssetsCash and equivalentsShort-term investmentsAccounts receivableInventoriesTotal current assetsNet plant and equipment2010100375615$1,000$1,00020091565315415$810870Tot
Berkeley - UGBA - 120B
PAGER/SGMLUserid: SD_77WMB DTD tipxLeadpct: 0% Pt. size: 8Fileid: D:\Users\77WMB\Documents\536\P536-Mar 29.xmlPage 1 of 22 of Publication 536tDraft(Init. & date)tOk to Print15:32 - 2-APR-2010The type and rule above prints on all proofs includin
Berkeley - UGBA - 120B
Enter the letter corresponding to the response that best completes each of the following statements or questions.1Temporary differences arise when expenses are reported in the income statement:A)B)C)D)2B)C)D)After they are deductible for tax pu
Berkeley - UGBA - 120B
Answers to handout given at end of section electronic copy also available on bspace titled asCh16 multiple choice section handout1. A2. C : 50 x 40%3. C : 38 +12 -15 = 254. B : 750 x 40%5. B : 30 x 30%6. B : 545 x 40%7. B : (120 45) x 40%8. C : 4
Berkeley - UGBA - 120B
Enter the letter corresponding to the response that best completes each of the following statements or questions.1In an employer-sponsored defined benefit pension plan, the interest cost included in the pension expenserepresents:A)B)C)D)2B)C)D)
Berkeley - UGBA - 120B
Answers to handout given at end of section electronic copy also available on bspace titled asCh17 multiple choice section handout1. B2. C3. C4. B5. A : 144 + 36 + (144 x 10%) - 306. B : 480 + 150 105 + 157. D : Pension liab is diff b/w PBO and FV
Berkeley - UGBA - 120B
Chapter 18 - Answers to handout given at end of section electronic copy also available onbspace titled as Ch18 multiple choice section handout1. B - The value of the property dividend is the fair value at the declaration date ($58). The gainis the diff
Berkeley - UGBA - 120B
Chapter 19 - Answers to handout given at end of section electronic copy also available onbspace titled as Ch19 multiple choice section handout1. D - Total compensation ($5 x 30,000) / vesting period (3 years)2. D - The new shares are time-weighted, but
Berkeley - UGBA - 120B
Chapter 16Accounting forFOR REVIEW OF KEY QUESTIONS Income Taxes TOPICSQuestion 16-1Income tax expense is comprised of both the current and the deferred tax consequences of events and transactions already recognized. Specifically, it includes (a) the i
Berkeley - UGBA - 120B
Chapter 1 Practice Problem Answers1. B2. C - (150,000 x $.85) is equal to $127,5003. D - Equity in Investee Income (150,000 x $.85) is equal to $175,0004. D5. A6. C7. E8. A9. A10. C11. C12. D13. E14. D15. E
Berkeley - UGBA - 120B
Chapter 1 Problems(See related pages)1Item is based on the following information:On January 1 of the current year, Barger Company buys 150,000 shares of Booker, Inc.'s common stock for$1,200,000, the book value of the shares. This purchase gave Barge
Berkeley - UGBA - 120B
UGBA 120B: Section LectureSegmentsEric DesaiWhat are Segments?Component of the enterprise that (SFAS 131): engages in business activities, earns revenuesand incurs expenses is regularly reviewed by decision makers discrete financial information is
Berkeley - UGBA - 120B
UGBA 120B: Chapter 9 Section LectureDerivativesEric DesaiFinal ExamStrategy1. Go through slides and concepts2. Do the practice exams (remember: they are themost representative of the final!)Tactics1.Partnerships focus on problems and differentsc
Berkeley - UGBA - 120B
UGBA 120B: Chapter 14PartnershipsEric DesaiPartnershipsADVANTAGESFlexibility in definingrelationshipsEase of formation and dissolutionTaxes flow-through thepartnership (conduit) tothe partners, and aretaxed to the individuals(no double- taxati
Berkeley - UGBA - 120B
UGBA 120B: Chapter 14PartnershipsEric DesaiHomework 14-16a. Goodwill MethodImplied value of partnership ($80,000 40%) .Total capital after investment ($70,000 + $40,000 + $80,000)Goodwill . . .$ 10,000$200,000190,000Goodwill to Hamlet (7/10) .
Berkeley - UGBA - 120B
UGBA 120B: Chapter 16-17 Section LectureGovernmental AccountingEric DesaiGovernmental AccountingWhy a separate accounting system?SizePublic needsNot for profitGASB similar to financial accounting, but:Different terminology and proceduresThree us
Berkeley - UGBA - 120B
UGBA 120B: Chapter 18Not For ProfitEric DesaiNot-For-Profit They receive contributions from donors who do notexpect a return of equal financial value Their operating purpose is not providing goods andservices for profit They do not have ownership
Berkeley - UGBA - 120B
UGBA 120B: Chapter 18 ProblemsNot for ProfitEric DesaiMCQIn accruing patient charges for thecurrent month, which one of thefollowing accounts should a hospitalcredit?A. Accounts Payable.B. Deferred Revenue.C. Unearned Revenue.D. Patient Service
Berkeley - UGBA - 120B
UGBA 120B: Section 1Advanced AccountingTimotej GavrilovicTimotej GavrilovicEDUCATION.MBA Candidate 2011, Walter A. Haas School of Business.B.A. Financial Management, Braca Karic University,Begrade, SerbiaWORK EXPERIENCE:PricewaterhouseCoopers, Au
Berkeley - UGBA - 120B
E16-9Deductable/TaxableProblemD1DTDT2345D6D7D8T9D10E16-10 Balance sheet accountAccrual of loss contingency, tax-deductible when paid.Liability loss contingencyNewspaper subscriptions; taxable when received, recognized forfinanc
Berkeley - UGBA - 120B
UGBA 120B: Section 2TAXESTimotej GavrilovicDeferred tax assets and liabilitiesThe InternalThe InternalRevenue Code isRevenue Code isttheset of rules forhe set of rules forpreparing taxpreparing taxrreturns.eturns.GAAP is the set ofGAAP is t
Berkeley - UGBA - 120B
UGBA 120B: Section 2TAXESTimotej GavrilovicE 16-4At YE2008, Payne Ind had deferred tax asset w/ balance of $30mil, due toa temp. difference of $75 mil.At YE2009 temp diff is $70mil; taxable income is $180 mil; tax rate 40%1. Prepare journal for inc
Berkeley - UGBA - 120B
UGBA 120B: Section 3Employee Benefit PlansTimotej GavrilovicSpecial tax Treatment Prerequisites1. Cover at least 70% of employees.1.2. Cannot discriminate in favor of highlyCannotcompensated employees.compensated3. Must be funded in advance of r