Assignment
In the last module, you build your database. But a database without any data isn't useful at all! In the last module, you build your database. But a database without any data isn't useful at all! So now that you have had some practice in writing SQL queries and you have a functional database in at least third normal form (from the previous module), it's time to populate your database and write some queries!
Step I
Populate your database that you created in module 5 with some representative testing data. Include at least 15 records for each of the tables (use INSERT commands or GUI tools provided by the DBMS you select).
Step II
Think of descriptions for six data querying requirements that could be answered from the data stored in your database, three requirements to change data already in the database, and three requirements to delete data already in the database. Answers to your querying requirements should contain at least two JOINs; two aggregation functions; a GROUP BY clause; and three WHERE or HAVING clauses. See the discussion instructions for examples.
Step III
In a Word document, prepare the following for each DML requirement you came up during Step II:
• The description for your requirement
• The DML statement (SQL command) that will get you the data you need - do not use a query generator or graphical tool to write this; write it on your own
• A screenshot of the resulting query output when executed on your database.
|
|
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
|