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.
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 the project text.
Relevant Skills and Experience
18+ years of software development.
Proposed Milestones
$20 USD - ERD
$25 USD - Rest of project
$45 USD en 3 días
5,0 (27 comentarios)
4,2
4,2
3 freelancers están ofertando un promedio de $107 USD por este trabajo
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 results that you have expected and we have already worked on a similar project before and can deliver as u have mentioned
We are sure you will not be disappointed if you give us this opportunity. Our team is experienced, creative & efficient enough to get your job done well. We have an impeccable record and all our clients enjoy working with us, we are sure that you will too, our prices are cheapest in market.
can u provide your email or sky-pe etc for further discussion about the project
I am ready to discuss with you
with best Regards