The context of designing Course Management

Assignment Help Basic Computer Science

Reference no: EM132666632

Question 1

What are the main reasons of setting up and managing databases in organizations?

Question 2

Explain briefly the key difference among the following concepts:

Transaction Processing System

Management Information System

Decision Support System

Give an example for each one of these systems.

Question 3

Using an example,explain briefly why MS Excel is not the best tool to set up large databases.

Question 4

Describe briefly the characteristics of columns and rows of a DB table. Explain the conceptual difference between columns and rows, illustrated by an example.

Question 5

Consider the following entities in the context of designing a Course Management System:

Students, Instructors, Courses. Propose a DB framework, without going into secondary details.How many tables you will need and how these should be related?

Question 6

A customer of a bank moves to a different city. Due to poor DB design, the bank requires the customer to submit address change requests separately for each of her four accounts held at the bank. What type of anomaly could result? How could this situation be corrected?

Question 7

You design a DB to manage information about projects your company's employees are currently working on. You know that several employees work on the same project, and an employee may work on different projects simultaneously.You were asked by management to create the following table to store the entire information:

TABLE (EmployeeID, FirstName, LastName, Street, City, State,ZipCode, Phone,

ProjectCode_1, ProjectName_1, ProjectClient_1, ProjectDueDate_1,

ProjectCode_2, ProjectName_2, ProjectClient_2, ProjectDueDate_2,

ProjectCode_3, ProjectName_3, ProjectClient_3, ProjectDueDate_3)

Is this table susceptible to insertion anomalies?Explain.Can you propose a better design?

Reference no: EM132666632

Questions Cloud

System testing and verification : Explain the Testing of activities for the given software: Test Design. Test Automation, Test Execution and Test Evaluation.

Penetration testing report : Prepare a plan to conduct a complete penetration testing on one or two targets. A planning and Pre-Attack phases are clearly addressed

Evaluate its preparedness for virtualization : Describe the organization's environment, and evaluate its preparedness for virtualization.

Design a conceptual rock breakage method : Design a conceptual rock breakage method, tool, machine, or any kinds. You can submit any conceptual idea or design related to rock breakage in mining

The context of designing Course Management : What are the main reasons of setting up and managing databases in organizations? Consider the following entities in the context of designing a Course Management

Future trends in information systems infrastructure : What are two future trends in information systems infrastructure and how do you think they will affect the way businesses

Evaluate your learning outcomes : Write a critical evaluation of your learning outcome. How would you apply your new knowledge?

Information-Gathering Techniques : Create a report for your Manager on Information-Gathering Techniques. Research techniques used to collect and gather information for the design of new system.

Reasons for two new auditing roles in oracle : Write an essay of discussing the reasons for the two new auditing roles in Oracle 12c.

User Account

All Pages