Create mysql database, Create two/three Tables under the

Create mysql database

Assignment Help Basic Computer Science

Reference no: EM132928586

1. Create a MYSQL Database.

2. Create two/three Tables under the database; ensure there is one-to-many or many-to-many relationship in between tables.

3. Write node code to insert data to all the tables. Create a generic function which will take the table name, query as parameter to insert data into the tables.

4. Write node code to get data from the tables. Create least 5 different queries to find data from database (the find queries must have combination of and/or/gt/ls/like commands available to retrieve data). Use table joins when you retrieving the data.

5. Write node code to update data into the table.

6. Write node code to delete data from table. When you delete data ensure that related data in the other table also get deleted.

7. How to submit the database:

1. Upload your node file.

2. Create a screenshot of the output of read, insert, delete, and update functions.

Reference no: EM132928586

Questions Cloud

Database security-principles : You are the webmaster of a college website. You share a server with other school departments such as accounting and HR.

Employers increasingly using workplace monitoring : Why and how are employers increasingly using workplace monitoring?

Consider the data flow octopus : Consider the data flow "octopus,". How can the analysis system gather data from all these sources that, presumably, are protected themselves?

Define and describe disaster recovery : Define and describe business continuity. Define and describe disaster recovery.

Create mysql database : Create two/three Tables under the database; ensure there is one-to-many or many-to-many relationship in between tables.

Kinds of devices into workplace : Some organizations prohibit workers from bringing certain kinds of devices into the workplace, such as cameras, cell phones, and USB drives.

What is the utility of detached signature : What is the difference between a MIME content type and a MIME transfer encoding? What is the utility of a detached signature?

What was the impact of security breach : Describe the incident. What was the impact of this security breach?

About how perception affects social situations : We use four types of cognitive schemata to make sense of perceptions: prototypes, personal constructs, stereotypes, and scripts

User Account

All Pages