Define database and database system

Assignment Help Database Management System

Reference no: EM132334513

Database Design I

Goal: This course is designed to introduce student to computer database

General Objectives: On completion of this course, the diplomates should be able to:

1. Understand the organization’s information need and database concepts.

2. Understand and differentiate the various types of data models

3. Understand how to model data

4. Understand the design of relational databases design

5. Know the structured query language (SQL)

6. Understand database systems architecture

1

1.1 Understand the types of information need.

1.2 Understand the purpose of data base systems

State types of information which organizations use.

Define database and database system.

State different purposes for database systems.

2

1.3 Understand data view and data model

1.4 Understand database administrators, users and languages.

Explain data view and models.

State different types of model.

Discuss different types of database languages.

3

2.1 Different types of data model: hierarchical, network and relational models

Explain the basic concepts of: hierarchical, network and relational models

2.1 (continued) Different types of data model: hierarchical, network and relational models

Explain structure data diagrams .

5

3.1 Understand the concept of E-R, entity sets ,entity relationship, weak entity sets.

Describe the basic concepts of E-R

Explain entity set and entity relationship diagram

3.2 Be able to design E-R database schema

3.3 Understand reduction of E-R schema into tables.

Explain weak entity sets

Discuss the design of E-R data base schema

Demonstrate the reduction at E-R schema into tables.

7

4.1 Understand pitfalls in relational-database design

4.2 Understand decomposition and normalization

State the pitfalls in relational database design

Explain decomposition and normalization

8

4.3 Understand domain-key normal form

4.4 Review alternative approaches to database design.

Explain domain-key normal form.

Discuss the alternative approaches to database design

9 5.1 Understand the background of SQL Discuss the background of SQL

5.2 Understand the basic structure of SQL

Discuss the basic structures

10

5.3 Understand nested sub-queries

5.4 Understand derived relations and views

Explain rested sub queries

Describe derived relations

11

5.5 Understand views Explain views

Discuss how databases can be modified.

5.6 Understand joined relations

5.7 Understand data definition language and embedded SQL.

Discuss joined relations

Demonstrate the implementation of data definition language and embedded SQL

13 6.1 Understand centralized systems

6.2 Understand client- server systems

Explain centralized systems

Explain client server systems

14 6.3 Understand parallel systems

Explain parallel systems

15 6.4 Understand distributed systems and network types

Differentiate between distributed systems and networked systems.

Reference no: EM132334513

Questions Cloud

Organization for using project management standards : ETI3440 Fundamentals of Project Management: What are the benefits to an organization for using project management standards?

What cultural consideration do you need to take into account : What cultural considerations do you need to take into account for your particular audience/topic? How are you going to keep the audience's attention throughout.

Describe the theory of abraham maslow : How has the theory of Abraham Maslow increased our understanding of personal and Organizational needs and satisfaction?

What criteria would you set early on in the process : A colleague from another country has limited English-speaking skills and does not comprehend the group task. Additionally, this colleague has the habit.

Define database and database system : COM 312 -Database Design I -NATIONAL BOARD FOR TECHNICAL EDUCATION HIGHER NATIONAL DIPLOMA IN COMPUTER SCIENCE.Define database and database system.

Select geologic feature in your hometown or region : Select geologic feature in your hometown or region and conduction virtual fieldtrip. Examples may include local caves, lakes, glacial deposits, rock formations.

How can you manage your emotions in a conflict situation : How can you manage your emotions in a conflict situation so that you remain aware of how you are communicating and listening?

Where in stages of listening did you experience breakdown : Where in the stages of listening did you experience breakdown? What was the reason you failed to listen effectively? Were listening barriers present?

How can our understanding of perception help us : How can our understanding of perception help us become more effective communicators? Think of time when you interacted with someone from a different culture.

User Account

All Pages