Database system
Budget: $10 – $30 USD
• You have to design a Database system for an Organization.
For ex.
i) University Database System
ii) Company Database System
iii) Hospital Database System
iv) Restaurant Management Database System
v) Payroll/Salary Management Database System
vi) School Management Database System
vii) Inventory Control Management Database System
viii) Library Management Database System
ix) Library Management Database System
[These are only suggested databases, you can choose from the list or any of your choice]
• PHASES OF DATABASE DESING (Consists of 4 phases)
Start with the 1st Phase
i. Requirements collection and analysis
The first step is requirements collection and analysis. During this step, the database designers interview or consult prospective database users to understand and document their data requirements. The result of this step is a concisely written set of users’ requirements.
ii. Conceptual Design – High-level schema
This ER model establishes a broad view of what should be included in the model set. Conceptual ERDs can be used as the foundation for logical data models. Conceptual data models:
a) Include important entities and the relationship between them.
b) Attributes and keys may be included here.
iii. Logical Design - High-level schema
This model contains more detail than the conceptual ER model, without regard to how the information will be physically implemented in the database. Logical data models:
a) Include all entities and relationships between them.
b) Specify attributes for each entity.
c) Specify the primary key for each entity.
d) Specify foreign keys, which identify the relationship between different entities.
e) Normalization typically occurs by dividing an entity table into two or more tables and defining relationships between the tables.
iv. Physical Design – Internal schema
The physical data model represents the process of adding information to the database. This model shows all table structures, including column name, column data type, column constraints, primary key, foreign key, and relationships between tables. Physical data models:
a) Specify all tables and columns.
b) Include foreign keys to identify relationships between tables.
c) May include denormalization, depending on user requirements.
d) May be significantly different from the logical data model.
e) Will differ depending on which DBMS (database management system) is used.
CRITERIA
Requirements Collection and Analysis
Conceptual Design
Logical Design
Physical Design
Project Report
Implementation using Query language
• You can use any of the software or tools to make physical design/relational diagram of the database, e.g. Oracle developer, SQL server, mySql, Visio, Smart draw, MS-Access, MS-Word, etc.
For ex.
i) University Database System
ii) Company Database System
iii) Hospital Database System
iv) Restaurant Management Database System
v) Payroll/Salary Management Database System
vi) School Management Database System
vii) Inventory Control Management Database System
viii) Library Management Database System
ix) Library Management Database System
[These are only suggested databases, you can choose from the list or any of your choice]
• PHASES OF DATABASE DESING (Consists of 4 phases)
Start with the 1st Phase
i. Requirements collection and analysis
The first step is requirements collection and analysis. During this step, the database designers interview or consult prospective database users to understand and document their data requirements. The result of this step is a concisely written set of users’ requirements.
ii. Conceptual Design – High-level schema
This ER model establishes a broad view of what should be included in the model set. Conceptual ERDs can be used as the foundation for logical data models. Conceptual data models:
a) Include important entities and the relationship between them.
b) Attributes and keys may be included here.
iii. Logical Design - High-level schema
This model contains more detail than the conceptual ER model, without regard to how the information will be physically implemented in the database. Logical data models:
a) Include all entities and relationships between them.
b) Specify attributes for each entity.
c) Specify the primary key for each entity.
d) Specify foreign keys, which identify the relationship between different entities.
e) Normalization typically occurs by dividing an entity table into two or more tables and defining relationships between the tables.
iv. Physical Design – Internal schema
The physical data model represents the process of adding information to the database. This model shows all table structures, including column name, column data type, column constraints, primary key, foreign key, and relationships between tables. Physical data models:
a) Specify all tables and columns.
b) Include foreign keys to identify relationships between tables.
c) May include denormalization, depending on user requirements.
d) May be significantly different from the logical data model.
e) Will differ depending on which DBMS (database management system) is used.
CRITERIA
Requirements Collection and Analysis
Conceptual Design
Logical Design
Physical Design
Project Report
Implementation using Query language
• You can use any of the software or tools to make physical design/relational diagram of the database, e.g. Oracle developer, SQL server, mySql, Visio, Smart draw, MS-Access, MS-Word, etc.