Given Codd's Rule 4:

Rule 4: Dynamic online catalog based on the relational model: The database description is represented at the logical level in the same way as ordinary data, so that authorized users can apply the same relational language to its interrogation as they apply to the regular data.

In three sentences, explain what this means. Give two example queries from MySQL that show how MySQL realizes the concepts

a.Imagine that the sponsor of Online Asset Management System project, which you are currently managing, suddenly decides to terminate the project early. What are two possible reasons for this decision?

b. Imagine you are creating a lessons learned database for the Online Asset Management System you have recently completed. What would you list as your top 3 issues? Your top 3 successes? (3 + 3 mark)

Need 600 words discussion

Key roles for a successful analytics project. Select a data analytics of your choice and discuss how the following roles add value to this initiative: Business User, Project Sponsor, Project Manager, Business Intelligence Analyst, Database Administrator, and Data Engineer. Again, please note that you will discuss specific activities that each of these roles may perform on a data analytics project that you select.

Database: Configure Oracle Net manager:

Create the directory E:\oracle\net to be used by Oracle Net configuration files and then set TNS_ADMIN variable to point to this. To set this variable you will need to open regedit.exe (the “Registry Editor”) first. Next, you will create and set the key TNS_ADMIN as a string variable in the registry in the Oracle Home branch. This will likely be: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDB12Home1

How to set TNS_ADMIN variable correctly.

Trying to discover a solution for sending data from the underwater facility to the surface so that it can be uploaded to the internet from a research facility on the edge of Mariana Trench, roughly 1 mile below the surface of the ocean. All data will be stored in Amazon cloud database for instant access by scientists from around the World. This needs to be uploaded to (AWS) amazon web services. WHAT CATEGORIES WILL I NEED TO CONSIDER for this to be possible. (Cause and Effects)

If you needed to identify inventory items whose stock was running low, what Access tool could quickly find this answer?

When you're creating relationships,, what Access option allows you to protect your database from inconsistent data?

Which tab or object should be selected if you want to create a data screen or user interface that would allow you to add, modify, or delete existing records?

A. Consider the following relations and relationship:

JobOpening (jobNo, positon, salary, requirement, contactPerson)

NewsPaper(newsPaperNo, name, street, city, zipCode, phoneNo)

       Posting(jobNo, newsPaperNo, date, cost)

1. List all the positions that are posted on January 01, 2016

2. List all the positions that have never been posted

3. List the names of all the newspapers where the positions “database administrator has been posted

Identify which cloud computing service model is appropriate to use in each of the following cases:

A company needs to build a web portal for clients all over the world to access web pages.

Google allows customers to do computing on their system. A customer does not need to have a powerful computer, just some means to access the Internet.

A small business does not want to purchase software, such as visio drawing tools and database.

The following relations are part of a school database:

STUDENT(STUD#, STUD_NAME, MAJOR, YEAR, GPA)

TEACHER(FACULTY#, DEPT, TEACHERNAME)

ENROLLMENT(STUD#, COURSE#, GRADE)

RESPONSIBILITY(FACULTY#, COURSE#)

Using PROJECT, SELECT and JOIN, write the sequence of operations to answer each of the following questions:

What are the names of teachers who are responsible for courses in which students whose name is 'JONES' are enrolled?

Use relational Algebra and relational calculus for this question.

Assume that due to some human resources problems, Frostburg Wires has to reduce the capacity of one of its four working stations by 1500 hours. Which working station can Frostburg Wires choose in order to minimize the impact of this change on its profit? USE EXCEL SOLVER

HERE IS ORGINIAL SCENARIO: