Käynnissä

Small Movies Database (no GUI)

Project description

You are required to design and implement a small Movies database application

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.

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;

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,

e, print out all the records in the table.

3, for each query:

a, describe the query;

b, provide the SQL statement for it

c, print out the results returned by the query.

Taidot: MySQL

Näytä lisää: simple gui client rs232, simple gui database, making flash movies small, java gui database project, excel gui database, examples create database movies, dynamic gui database, megarotic database movies, customizable rsync gui client, python simple browser, vba gui database processing, client email registration, vista rsync gui client, sample java gui database, database movies joomla, rsync gui client, use multi video uploader, client email database, simple gui database search, email form simple, rsync windows gui client, flash movies small, windows rsync gui client, professional email template simple, email template simple

About the Employer:
( 3 reviews ) Sanford, United States

Projektin tunnus: #13134942

Myönnetty käyttäjälle:

iqmax99

Bid Summary I can create the database in mySQL with ERD and answer questions as required. Project Requirements 4 tables to be used for modeling data about movies. DDL, ERD and SQL is to be developed as described in th Lisää

45 $ USD 3 päivässä
(27 arvostelua)
4.2

4 freelanceria on tarjonnut keskimäärin 86 $ tähän työhön

erharicharan

WebsOrange's primary aim is to make clients 100% satisfied by delivering the best quality services and projects. We are one of the leading off-shore company providing a wide variety of services in the field of web desi Lisää

250 $ USD 1 päivässä
(0 arvostelua)
0.0
rossowolf83

I'm expirienced MySQL developer. Done in past something like you've required. Think can handle it. Not bad training also. Thanks.

25 $ USD 1 päivässä
(1 arvostelu)
0.0
techcrunch2

Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the resu Lisää

23 $ USD 7 päivässä
(0 arvostelua)
0.0