GILAKAMEN RDMS!!!!!!: March 2011

Monday, 28 March 2011

weekly reflection 1

*today is the first class, lecturer divide group for us. she us each group to presant our name, moto and rules in a group.

*after that, we learn chapter 1. we learn about client and server. we also learn overview of DBMS. it's not much differences that what we learn in DADD except a four new things.

*in chapter 2, we learn about EER. there's superclass and subclass where we must determine which will become superclass or subclass.

*total specialization where every entity of superclass must belong to at least one subclass.

*partial specialization where at least one entity of subclass is not belong to any subclass.

*disjoint constraint is about a superclass can belong to most of subclass.

*overlapping constraint specifier that every number of superclass can belong to more than one of the subclass.

*generalization where an entity is made to combine and make a superclass.

*categorization where a single subclass with a relationship that involves more than one distinct superclass.

weekly reflection 4

* we learn how to put primary key and foreign key in the table.

*primary key: create table table_name(field_name1 datatype(field_size)primary key,
field_name2 datatype(field_size))engine=innodb;

*foreign key: create table table_name(field_name1 datatype(field_size)primary key,

field_name2 datatype(field_size),

foreign key(foreing_key_in_table) references table_name_to_be_refer(primary_key_to_be_references))engine=innodb;

WEEKLY REFLECTION 2

Today we continue our of RDMS of chapter 2 . it is about steps in working EER and there are 8 steps

Identify entity types
Identify relationship types
Determine cardinality constraints
identify and associate attributes
Determine candidate and primary key
Specialize/generalize entity types
Categorize entity types
Draw the EER diagram

We also learn about relational data model, it is the same as in DADD but only in design, we also learn about characteristics of relation which has 6 characteristic and about key functional dependencies and the formula is A --> B

Today also move to chapter3 about Database Development Process. on components of information system we learn about components of information systems which has 5 components.

People
procedure
Software
Hardware
Data

There are 5 Process in SDLC

Preliminary study
System analysis
System design
System Implementation
Maintainance

There are 2 methodologies in SDLC

Spiral Development Methodologies (Spiral)
Rapid application Development Methodologies (RAD)

DBLC is ssimilar to SDLC

Database initial study
Database design
Implementation and loading
Testing and evaluation
Operation
maintainance and evolution

Important in Database Development is skill. there are 2 skill needed which is

soft skill
hard skill

There are 2 tools of Database Development

font_end (upper_CASE)
back_end (lower_CASE)

weekly reflection 5

* we do some revision for midterm exam.

* a lot of sample past year question are given.

* the examples of question is :
- what is a DBMS?
-what do you mean by procedural access?
-what is the difference between a file based database and DBMS?
-list down some advantages of a DBMS.

WEEKLY REFLECTION 3

Start class on 11am
Download xampp
Rest
Miss explain how to do the database

how to create database
how to insert the data
insert the field name,data type
change column and field name

   5. Create table

   create table_table_table_name (field_name1 data_type (field_size),
   (field_name2 data_type (field_size),

   6. How to show all the table in the database you're created :

   show tables ;

   How to show your table that you're ceated

   describe table_name ;

   7. How to insert the record/data in table

insert into table_name values ("data1","data2","data3",....);
must be match with your field name when you insert the data

insert into table_name (field name 1,field name 2,......)

values ("data1","data2",....);

8. To display data that contains in table

-----> select * from table_name;

9. Change column / field name

alter table table_name change old_field_name new_field_name data_type (field_size);

Friday, 18 March 2011

tutorial 2

tutorial

Monday, 7 March 2011

Question 4

The following narrative describes a simplified version of the Organization of Olympic facilities planned from the 1996 Olympics in Atlanta. Draw an EER Diagram that shows the entity types, attributes, relationships and specializations for this application. State any assumptions you make.

The olympic facilities are divided into sports Complexes. Sports Complex are divided into one-sport and multisport type.Multisport complexes have areas of the complex designated to each sport with a location indicator (e.g, center,NE-Corner,etc). A complex has a location, a client organizing individual, total occupied area and so on.

Each complex holds a series of events (e.g the tract stadium may hold any different races). For each event these is a planned date, duration, number of participants, numbers of officials, and so on. A roster of all officials will be maintained together with the list of event each official will be involved in.

Question 3

The entity type DISTRIBUTOR has four subclasses:NORTHERN, SOUTHERN, CENTRAL and EASTERN. Draw a separate EER diagram segment for each of the following situations:

a) At a given time, a DISTRIBUTOR must be exactly one of these subclasses.

b) A DISTRIBUTOR may not be one of these subclasses. However, a DISTRIBUTOR who is one of these subclasses cannot at the same time be one of the other subclasses.

c) A DISTRIBUTOR may not be of these subclasses. On the other hand, a DISTRIBUTOR may be any two (or even three) of these subclasses at the same time.

Question 2

Question 1

a)Define what DBMS?

Database Management System (DBMS) is a software system that enables users to define, create and maintain the database and provides control access to this database.

b)Give TWO advantages of using a DBMS?

Control of data redundancy

Data consistency

c)Explain what are the THREE main database characteristics?

Persistent

Shared