Perform the conceptual database design using er model

Assignment Help PL-SQL Programming

Reference no: EM131965263

Project Assignment: Design and Implementation

Requirements

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.

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, print out all the records in the 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, print out the results returned by the query.

Send me email if you have any further questions.

Attachment:- Generate-Movies-Database.rar

Reference no: EM131965263

Questions Cloud

Differentiate between standardization-adaptation : Differentiate between standardization, adaptation, and glocalization. Provide an example of each.

Identify the factors that contribute to generator market : Identify the factors that contribute to generator market power, various market power indicesand theirpros and cons in quantifying.

What is the contribution of grab to the philippine economy : What is the contribution of Grab to the Philippine economy?

What is the cash flow from assets for given time : What is the cash flow from assets for 2012? (Do not round intermediate calculations. Negative amount should be indicated by a minus sign.)

Perform the conceptual database design using er model : Perform the conceptual database design using Entity-Relationship model. You must submit the Entity-Relationship diagram of your database. In the E-R diagram.

Write a case report addressing the personal knowledge : Write a case report addressing the personal knowledge and skills gained in the current course and potentially solving an identified practice problem.

Participate in the festive daytime event : At the annual Post Corp. holiday lunch, a non-Christian employee does not want to participate in the festive daytime event

The purposes of social change or any other purpose : I think that researchers are obligated to not misuse a study for the purposes of social change or any other purpose.

Calculate depreciation for the first 2 years : How much depreciation would be shown on the Income Statement for each of the 4 years using the straight-line method?

User Account

All Pages