Closed

Mysql project

Project 3

2. For the 2 databases (DBs) you implemented in Project 2, (using MySQL or SQLite), perform the following sets of activities.

6. Extend both of your DBs to incorporate Constraints of various types. Include concrete examples for each of the following constraints and manipulations.

a. Non-NULL constraints.

b. On attributes: Attribute-based CHECK constraints.

c. On tuples: Tuple-based CHECK constraints.

d. Altering constraints on Tables

e.

7. Extend both of your DBs to incorporate Assertions.

8. Extend both of your DBS to incorporate Views and Indexes: Give concrete examples.

a. Views: Declaring, Renaming, Removal, Modifying, Updating, Materializing.

b. Indexes: Declaring.

9. Provide a comprehensive record of using SQL (MySQL) to query and manipulate the databases you have created. Your record should include concrete examples of queries and manipulations on both DBs. (See also Quiz 3).

a. DB modification via Insertion, Deletion, Updates.

b. SELECT-FROM-WHERE queries, emphasizing varieties of SELECT clauses; FROM clauses; WHERE clauses

c. Queries emphasizing ORDER BY clauses

d. Queries emphasizing GROUP BY clauses

e. Queries emphasizing HAVING clauses

f. Queries emphasizing Sub-queries

g. Queries emphasizing use 2 or more tables in a query.

h. Queries emphasizing Set Operations, Join Expressions, Returning Unique records

i. Queries emphasizing Aggregation Operations

10. Document and present your design as a report in the following form:

Title

Author

Date, Revision Number

Problem to Solve

SQL Uses. (Provide details in an Appendix)

Discussion

Summary & Conclusions

Acknowledgments, (if any)

References, (if any)

Appendix:

Constraints

Views

Indexes

Assertions

Triggers (Extra Credit)

Security Implementation (Extra Credit)

Normalization Analysis (Extra Credit)

Project 4

2. Do one of the following projects.

3. Choose one of the 2 databases (DBs) you implemented in Project 1 – Project 3, (using ER model, RM model, SQL model: MySQL or SQLite), and re-design or re-engineer it into an XML database. Choose either DTD or XML Schema to specify the DB’s document schema.

4. Provide a DB Architecture that could potentially support the “Big Data” needs of a real-life institution or corporation. (Some suggestions are provided in Appendix A). Your design and architecture should include the following aspects, which will demonstrate that you have deeply thought about the issues involved and generated some insights:

5. Document and present your design as a report in the following form:

Title

Author

Date, Revision Number

Problem to Solve

XML DB or “Big Data DB Design”. (Provide details in an Appendix)

Discussion

Summary & Conclusions

Acknowledgments, (if any)

References, (if any)

Appendix:

(a) XML DB

Cross-reference ER and RM DB design

Semi-structured Model design

Document schemas (DTD or XML)

XML DB details: graphs or networks, tables

(b) “Big Data” DB

Skills: MySQL, XML

See more: form mysql, mysql design, queries emphasizing clauses, queries emphasizing group clauses, types of data graphs, rm group, real expressions, problem set analysis, n. c. h. corporation, implementation of graphs, graphs uses, examples of databases, xml dtd, unique insights, support engineer, sql mysql, sql data analysis, project engineer, normalization, mysql to sql, ER Model, sqlite design, data analysis projects, mysql number sql, big databases

About the Employer:
( 4 reviews ) Queens village, United States

Project ID: #4516982

6 freelancers are bidding on average $148 for this job

harish1984

Hi, Please see your Inbox.

$236 USD in 3 days
(25 Reviews)
5.0
farhaoui

HI, READY TO START WORK. LETS START AND FINISH IT ASAP. I HAVE 8 YEARS OF EXPERIENCE IN WEB DEVELOPMENT FIELD ( PHP, MYSQL, AJAX, JQUERY, HTML, CSS... ). THANK YOU !!

$206 USD in 3 days
(13 Reviews)
4.2
it2051229

Hi, I would like to do this project please. Let me know if you are interested so I can start. Thanks.

$50 USD in 1 day
(16 Reviews)
4.0
osnofasl

Good evening. I am computer engineer, so I am ready and able to do the job. Need some more details on some of the tasks and also to have the startup database. Thanks in advance. Best regards.

$222 USD in 10 days
(1 Review)
1.5
LaGuardia

Ready to start work

$45 USD in 2 days
(2 Reviews)
1.1
khp31

Sr. Software Developer with 4.4 yrs experience.

$111 USD in 3 days
(0 Reviews)
0.0
xuliang482

I can do it for you

$222 USD in 3 days
(0 Reviews)
0.0