+======================================+
          |      DATABASE SYSTEMS PROJECT        |
          |               Phase I:               |
          |     Conceptual Database Design       |
          +======================================+

     In the database system class, each student in the class will
work on a database application project. The project will design and
implement the software for a business or a enterprise he/she choose.

     The project will divided into several phases. Each student will
document the entire project with code writing, and present the project 
present the project to the class during the process of implementation
of the project.

     The project for this course is divided into serveral steps/phases including

	1. Fact-finding and data gethering: The data views and
	   operations on data collected and documented, and
	   are organized by user groups in this phase.
	2. Conceptual database design: Using E-R Modeling format the
	   information gethered in step 1.
	3. Logical Database Design: Convert a conceptual E-R DB to
	   relational database.
	4. Creation of Database with PostgreSQL DBMS System: Create tables
	   indexes, views, triggers, stored procedures and etc. Load data.
	5. Interfaces for User Group(s): Design and implement end user
	   program(s) for specific group(s) of users in C#. The interface
           could be window-based local application or web-based internet
           application 

    For this phase, you will complete two things

        1.1 Data/Information Collection. 
        1.2 Conceptual database design.

    Study, conduct and documnent information used in company and conceptual database
design. The detailed requiremts for what need to be documented are described
section 1.1 and 1.2. 

	1.1 Fact-Finding/Data Collection  Techniques and Information Gethering

       Brief generate desciption of sections from 1.1.1 to 1.1.5

	   1.1.1   Introduction to Enterprise/Organization: Description on the
               business; what the business is doing, and its activities.
	   1.1.2 Description Fact-Fining Techniques; Describe the fact-finding
               methods you have used to gether the data, and the operations
               on data such as who entering what data, and what reports will
               be generated from the database.
	   1.1.3 The part of enterprise you are designing conceptual database
               for. Your database may not cover the entire enterprise.
               Describe major entity types and relationship types that you will
               include in your database.
       1.1.4 Itemized descriptions of Entity Types and relationship Types: 
               For each entity type, describe eacch attribute's 
                    name, type, meaning of the value, give a example of entity instance
                    how the entity type related to others.
               For each relationship: describe its name, meaning, descritive attributes
                    and the related  entity typess, constraints of relationship, and
                    give an example of relatiionship.
	   1.1.5  User Groups, Data views and Operations: A user group is a group of users 
               accessing database is similar way on maybe on different data. For Example,
                Secretaries of all departments are in one user group. Online storrebuyers 
                of a store are one group users. Data views is view or pictures of all
                data accessible to user group. The operations for each user group may
                different. For an online shoper need to items, purchasing history and
                imcompleted order, adding and removing items from curent orders and etc. 


	1.2 Conceptual Database Design

       Brief generate desciption of sections from 1.2.1 to 1.2.3.

	   1.2.1 Entity Type Desciption

		Entity Type UVW:
			* name (use intuitive name
			* description: what is the purpose of the entity
			  type, what information are held in the entities.
			  The relationship(s) with other entity type(s), and other information
			  about the entities in the set (such the frequencies
			  of insertion, deletions, and updates).
			* Attribute description
				- name
				- descriptin
				- domain/type
				- value-range
				- default value
				- null value allowed or not?
				- unique?
				- single or multiple-value
				- Simple of Composite
				
			* candidate keys:
			* primary key:
			* Strong/Weak Entity
			* Fields to be indexed

	 	Entity Type XYZ:
			...

	   1.2.2 Relationship Type Description

		Relationship ...:
			* Name (use intuitive name)
			* description: What is the relationship type for, the
			   purpose of relations, what are the entities involved,
			   meaning of each descriptive data field. Multiplicities
			   and mapping cardinality.
			* Entities involved
			* Mapping cardinality
			* Desciptive field
			* Participation Constraint:
				Partial/optional or total/mandatory

	   1.2.3 Related Entity Types 

	       Describe the following and point out entity types and relationships
	       that are derived with the specialization/generalization process.

		* Specialization/Generalization Relationships(is-A)
		   	Participation constraint
			Disjoint constraint
		* Aggregation/has-relationship
			Composite
		
	   1.2.4 E-R Diagram

		Label the entity types with attributes, relationship types,
		multiplicities.