Question:

I'd like to test PostgreSQL code against the following:

1: Insert normal data

2: Insert non-exist foreign key.

3: Insert duplicate rating.

4: Insert a hasagenre record that contains wrong genre id.

5: Insert a rating larger than 5.

** Please Note: The answer will just call for SQL script. SQL script should NOT contain the commands to change the database or set encoding. Please do not use any commands to change Postgres DB settings. All table names and attribute names must be in lowercase letters and match the specification.* *

Here is a description of tables:

users: userid (int, primary key), name (text)

movies: movieid (integer, primary key), title (text)

taginfo: tagid (int, primary key), content (text)

genres: genreid (integer, primary key), name (text)

ratings: userid (int, foreign key), movieid (int, foreign key), rating (numeric), timestamp (bigint, seconds since midnight Coordinated Universal Time (UTC) of January 1, 1970)

tags: userid (int, foreign key), movieid (int, foreign key), tagid (int, foreign key), timestamp (bigint, seconds since midnight Coordinated Universal Time (UTC) of January 1, 1970).

hasagenre: movieid (int, foreign key), genreid (int, foreign key)

Please Note: The requirement only tells you the name and data type of each attribute in each table. Please determine the primary keys, foreign keys, constraints or other necessary settings for the database. The key information in the requirement is just a skeleton and not complete; attributes can be primary keys and foreign keys at the same time.

3. Metal coordination compounds are difficult system for molecular mechanics methods. Why is this? (Please discuss this in detail.) 4. What are the advantages and disadvantages of semi-empirical methods in term of transferability from one set of compounds to another, and in term of comparing chemically disparate system? 5. Name and explain six energy terms included in molecular mechanics?1) What is finance? Define business finance. 2) Explain the types of finance. 3) Discuss the objectives of financial management. 4) Critically evaluate various approaches to the financial management. 5) Explain the scope of financial management. 6) Discuss the role of financial manager. 7) Explain the importance of financial management. 8) What is financial engineering 9) List three to four international undergraduate and graduate programs of financial engineering