What is a database? And how does it differ from a file system?After you’ve read through the articles and related materials, think about their content carefully and compose a short (3- page) paper on the topic:
Assignment 2
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- 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–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- topage 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.
Assignment 3
Module 1 – SLP
Data, Database, Database Management System, and Relational Database Modeling
The SLP Project in CSC316 spans from Module 1 to Module 4. You are required to apply what you have learned in previous modules to the assignment in the current module. That is, the Module 2 SLP is built on the Module 1 SLP assignment, and the Module 3 SLP is built on the Module 2 assignment, etc. Please follow the instructions below closely:
Problem Definition
A used-book store has been in business for over a month. The owners have been so busy that they have not had time to design and implement a computer-based system to track their operation. Their first priority is to develop a database management system to track inventory and sales information.
You are hired to design, program, and implement the system. You will be working on elements of this system in the rest of the SLP assignments in this course.
The owners provide you with the following facts:
The bookstore sells used and hard-to-find books and CDs. Sales are for cash/check or credit card.
The bookstore mainly caters to the needs of people living in the area.
The bookstore maintains an inventory of books and CDs.
Store sales are recorded at a Point-of-Sale (POS) terminal.
PLACE THIS ORDER OR A SIMILAR ORDER WITH NURSING HOMEWORK HELP TODAY AND GET AN AMAZING DISCOUNT
