Design and implement a small database application to manage manage 10 top grossing U.S. movies of all-time by storing and manipulating the data of movies,actors/actresses, directors, year released, and $gross.
Design and ImplementationPerform the conceptual database design using Entity-Relationship model. 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 the E-R diagram to logical database model. Design the table structure, includingall needed attributes for each table. Submit the relational database schema, which consistsof the description of all tables, constraints in the database. For each table, please specify theprimary key and foreign keys.
Implement the design using SQL. Create all the tables and develop queries in SQL. Generate and load appropriate, consistent data into thedatabase. In MySQL, submit the DDL statements you used to create the tables, to define the constraints, and the SQL statements for all the queries.
QueriesDesign and develop at least 6 queries in the 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 ReportThe report:1, must describe your database application;2, must submit the conceptual and logical design of the database as specified in sectionDesign and Implementation, which include the E-R diagram and relational database schemaof the 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 used to create the table, or the screen snapshots if GUI used;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 GUI used, provide the screen snapshotsand the equivalent SQL statement;c, include the results returned by the query in the final report.
The post Design and implement a small database application to manage manage 10 top grossing U.S. movies of all-time by storing and manipulating the data appeared first on My Assignment Online.
