MCIS 630 Database Systems Essay Assignment
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
MCIS 630 Database Systems Essay Assignment
Final Project Description and Requirements MCIS 630 Database Systems (Winter 2013) Total: 30 points Due date: 4/26/2013 11:59PM System description You are required to design and implement a small database application to manage any data you are interested in.
Some examples are listed below for your reference: 1, if you have a collection of CDs, you can manage the data of albums, musicians, songs, companies etc. 2, if you are interested in NBA/NFL games, you can manage the data of players, teams, coaches, matches etc. 3, you can also manage your favorite movies by storing and manipulating the data of movies, actors/actresses, directors etc.
Design and Implementation Perform the conceptual database design using Entity-Relationship model. You must submit the Entity-Relationship diagram of your database. In the E-R diagram, 1, there must be at least 4 entities; 2, there must be at least 2 one-to-many/one-to-one relationships; 3, there must be at least 1 many-to-many relationship.
Convert your E-R diagram to logical database model. You are to design the table structure, including all needed attributes for each table. You must submit the relational database schema, which consists of the description of all tables, constraints in your database. For each table, please specify the primary key and foreign keys.
Decompose your design to be in BCNF or 3NF if necessary. Implement your design using any DBMS. You are required to create all the tables and develop queries in the target DBMS. You must generate and load appropriate, consistent data into your database. You must submit the DDL statements you used to create the tables, to define the constraints, and the SQL statements for all the queries.
Queries You must design and develop at least 6 queries in your database application, among them, 1, at least 2 queries are multi-table queries; 2, at least 2 queries use SQL aggregate functions; 3, at least 1 query uses subquery; 4, NULL search condition should be used at least once; 5, GROUP BY and HAVING clause should be used as least once. Project Report In your report: 1, you must describe your database application; 2, you must submit the conceptual and logical design of your database as specified in section Design and Implementation, which include the E-R diagram and relational database schema of your database.
For each table: a, describe all the attributes (including attribute names, data types etc.); b, specify the primary keys and foreign keys (if exist); c, discuss which Normal Form it is in; d, provide the SQL DDL statement you used to create the table, or the screen snapshots if your used GUI; e, print out all the records in the table. 3, for each query: a, describe the query; b, provide the SQL statement for the query; c, print out the results returned by the query. Send me email if you have any further questions. Thanks.
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow MCIS 630 Database Systems Essay Assignment
MCIS 630 Database Systems Essay Assignment