MSIT630: Entity-Relationship Model - SQL Aggregate Functions - IT/Computer Science Assignment Help

Assignment Task

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 the 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. 
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. Two options are listed below, 
1, MySQL: for this option, you must submit the DDL statements you used to create the  tables, to define the constraints, and the SQL statements for all the queries; 
2, Microsoft Office Access: for this option, you must submit the screen snapshots of design  views of all tables and queries. For each query, the equivalent SQL statement must be  provided as well. You must also include the database relationships diagram, which shows the relationships between tables. 
For other DBMSs, the requirements are similar to option#1. The bottom line is that you have to  submit materials to show how you created the tables and 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, Output all the records in the table using “Select * from example_table;”. 
3, for each query: 
a, describe the query; 
b, provide the SQL statement for it, or if you used GUI, provide the screen snapshots  and the equivalent SQL statement; 
c, include the results returned by the query in your final report. 
Send me email if you have any further questions. Thanks.

This MSIT630: IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.