Module 1 Case Assignment Coursework: Database Management

Order 100% Plagiarism free paper

Module 1 – Case DATA, DATABASE, DATABASE MANAGEMENT SYSTEM, AND RELATIONAL DATABASE MODELING 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). And then download SQL developer at http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html. 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 For students who are not able to download software due to access restrictions: Write a 2- to 3-page paper (excluding cover page and references) comparing features and characteristics of various types of DBMS (Oracle, Access, and MySQL). 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 screen shots 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 as table, schema and key. Describe the tables in the HR database.

source..