Creating an excel spreadsheet

Details: In this project, you will create an expense report for a company's sales force, then save it. To view these instructions while you work in Excel, do either of the following: Print this page of instructions or move back and forth between this page and Excel by clicking each application's button on the Windows taskbar ...continues

Design a physical data model

For each of the following exercises design a physical data model. The data model should include table names, column names, datatypes, an indication of whether each column may be null or must be not null, relationships in crow’s foot notation including minimum and maximum cardinality, and all primary and foreign keys must be p ...continues

Create function in SQL

I need a simple SQL program demonstrating the use of CREATE FUNCTION command in SQL. A create table can be used to generate a simple record of items such as name, title, age. The Create Function command will be used to retrieve one specific value. The program should demonstrate and show how you can pass a variable in and outp ...continues

Oracle 10g

What advantages (if any) are there to using data files over a database system?

Oracle 10g

Which of the data dictionary views are most useful, and why?

Excel Formulas

I need help with the attached 3 sheets. The formula matching I need explained what and why would match each letter to each statement but does not have to be answered, I am more concerned with the formula sheets. The other 2 sheets are formula related and I need those explained as to which formula to use and how.

Relational schema diagram (ID all dependencies to include transitive)

Using the STUDENT table structure attached, write the relational schema and draw its diagram. Identify all dependencies (including all transitive dependencies)

Which one is more feasable?

As we start designing a database for implementation should we use the latest and greatest technology? Does the user need a flat-file or object-oriented database? Give an example of each and how it would apply to the basic database designer goo roo.

Database management systems

Describe database management systems and what they are used for. (Consider Microsoft Access, SQL Server, Oracle, DB2, etc.)

Differences between row-level, column-level, and table-level locking?

Can anyone tell me the differences between row-level, column-level, and table-level locking? Why would you need to use them?