Please answer the following

Describe the advantages and challenges of using a team to develop an Access database.

Relational Algebra

From the following relations, write the Relational Algebra to: Find the part(s) that have been supplied by more than one vendor during February. Vendors(vend#, vend_name, vend_phone) Parts(part#, part_desc, part_price) Supplys(vend#, part#, supply_date)

ROLAP and MOLAP

What is the difference between ROLAP and MOLAP. Which is perferred? Why? (Please include citiation/references)

OLAP client/server

The data warehousing project group has invited you to provide an OLAP overview before making a commitment. The group's members are particularly concerned about the OLAP client/server architecture requirements and how OLAP will fit the existing environment. Your job is to explain to them the main OLAP client/server components and architectures. Please provide references

Data Fields

Using Microsoft Word, list all of the data fields that would be needed for a sales contact database system. Think of it as an extended address book with additional fields to keep track of things that interest salespeople. The only requirements are that you must consider how to store notes about the contact, track any follow up items, and store multiple phone number for each contact. Be sure to include the field type and size. Please do not jump ahead and try to create tables. Right now I'm just looking for a list of fields. This is somewhat vague on purpose. I want you to decide what is needed in the database. This is what I did for the above instruction. And I want someone to help me... click for more