Assume that Garden Glory designs a database with the following tables.
OWNER (OwnerID, OwnerName, OwnerEmail, OwnerType)
PROPERTY (PropertyID, PropertyName, Street, City, State, Zip,OwnerID)
GG_EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel)
SERVICE (PropertyID, EmployeeID, ServiceDate, HoursWorked)
The referential integrity constraints are:
OwnerID in PROPERTY must exist in OwnerID in OWNER
PropertyID in SERVICE must exist in PropertyID in PROPERTY
EmployeeID in SERVICE must exist in EmployeeID in GG_EMPLOYEE
Prepare tables and data:
1.Download Assign-3-create-tables.sql, Assign-3-insert-data.sql, and Assign-3-delete-tables.sql from ANGEL->Solutions->Homework Assignment 3 Solution
2.Delete the tables you have created for Assignment 3-1 in your database usingAssign-3-delete-tables.sql
You are required to develop a web based matching system, for example matching of jobs required by employers to skills of potential employees,
1.Potential employers post the details of the kinds of employees they are looking for and job seekers post their skills and experience and the system matches employers to job seekers.
2.Sellers post descriptions of items they have for sale and buyers post descriptions of items they want to buy and the system matches buyers and sellers.
3.Trades people post their expertise and location and householders post details of problems they want fixed or jobs they want done.
4.A matchmaking site.
5.Any other producer-consumer situation of your choice.
The system must:
- Permit users to register
- Provide the necessary transactions for data entry
- Provide appropriate matching algorithms
- Operate from desktops and mobile devices
- Provide appropriate admin functionality
You can ad
In this assignment, you will show that you can work with different NoSQL systems for
data persistence and understand the strength and weakness of each system with respect to
certain workload features. You are asked to work with a music data set and a list of target
queries. You will design data schema based on the data set feature and the given query
workload for MongoDB, Neo4j and HBase respectively. You will show that your design can
support the target queries by load the data in each system following your schema and run
queries against the data.
理解MongoDB, Neo4j 和HBase的的设计和persistence