professional database people only
sam83
M5A11.docx4
|
|
MySQL DB |
Oracle DB |
MS ACCESS |
MSSQL |
|
|
publisher |
Oracle |
oracle |
Microsoft |
Microsoft |
|
|
License |
Open source |
commercial |
commercial |
commercial |
|
|
System Requirements |
Ram |
256mb |
256mb-512
|
I gbh-2gb |
512mb I gb |
|
|
Disk space |
600mb |
2.04gb |
3.0 gb |
6gb |
|
|
Video adapter |
800*600 |
256colors |
1024*768 |
800*600 |
|
|
processor |
any |
550mz minimum |
*86 bit or *64bit intel processor |
1.4ghz -2.0ghz X64 |
|
|
|||||
|
Management tools |
MySQL workbench |
Oracle 11 client |
|
Sql server management studio |
|
|
Features |
Cross-platform Stored-procedures Triggers Ssl support |
Bi & data warehousing Database cloud Information integration Security and compliance |
Ready templates Easier to understand
|
End-to-end business intelligence Unlimited virtualization End user access to data insights |
For this exercise I choose to use MySQL Db since it’s an open source. Besides that, it’s easy to manage using the MySQL workbench. MySQL database is easy to install it has a small size and a small footprint. MySQL database also comes with documentation in time and sample databases embedded
|
table |
DDL |
|
Student |
|
|
|
|
|
student |
|
|
parents |
|
|
|
|
|
Health record |
|
|
tuition |
|
|
grade |
|
|
teacher |
|
|
Class record |
|
|
Teacher info |
|
This exercise was a good exercise as it give us a real world database sample to work out with. This exercise was a bit challenging coming out with entities and deciding if an entity is a strong or a weak entity was able to locate all the reference material. In the next exercise will collect enough data for a database so that can be able to capture all the user requirements
References
Connolly, T., Begg, C. (2002), Database Systems, A Practical Approach to Design, Implementation and Management (3rd ed.), Addison Wesley
Koch, K. L. G. (2000). Oracle 8i: The Complete Reference. Berkeley, Osborne.
Simson, G. C. (1994). Data Modelling Essentials (Analysis, Design and Innovation). Arizona, International Thomson Computer Press.
Weinberg, J. R. G. P. N. (1999). SQL: The Complete Reference. Berkeley, Osborne.
