case data, DATABASE, DATABASE MANAGEMENT SYSTEM, AND RELATIONAL DATABASE MODEL Case Assignment Case assignment in this module consists of two parts:
data mining
Description
case data, DATABASE, DATABASE MANAGEMENT SYSTEM, AND RELATIONAL DATABASE MODEL Case Assignment Case assignment in this module consists of two parts: Part A: After you've read through the articles and related materials, think about their content carefully and compose a short (3- to 4-page) paper on the topic: An Overview of Database and Database Management System Part A assignment expectations You should include the following topics in your discussion, not necessarily in the same order: What is a database? And how does it differ from a file system? What is a database management system? And why is it needed? What are the advantages of DBMS? What are the advantages and disadvantages of RDBMS and ODBMS? What issues should be considered when choosing a database and a DBMS? What are the roles of a database and a DBMS for an organization's information system? Part B: You will install Oracle database 11g express edition and SQL developer to your computer, validate your installation, and write a short 3- to 4-page paper with screenshots of your download. To work on this assignment, you will need to first reading the following materials: Oracle Express Installation Guide (2011). Oracle Express Getting Started Guide(2011). Make sure you download the zip file that includes the JDK1.6.0_35. In the end, learn how to connect to Oracle database using SQL developer. Alternative assignment: Conduct an extensive research on Oracle and Access. Write a 3- to 5-page report that discusses their respective features, characteristics, strengths, and weaknesses. You can also submit a PowerPoint presentation or a video as homework. Part B assignment Expectations Successfully install Oracle database 11g express edition and Oracle SQL developer to your computer. Describe your experience with the installation. Open the sample database HR, make screenshots of the database, and copy them into your paper. Open the HR database, describe what information you see there using the terms introduced in this module, such astable,schemaandkey. Describe the tables in the HR database.
