Understanding the Database Schema

For this application, we're using a SQL Server database to store the user, resume, and job-related information. To keep the application simple, we've used only three tables: Job, Resumes, and Users. The Job table has six columns (see Figure 17-2).

click to expand
Figure 17-2: Schema of the Job table

Figure 17-3 shows the Resumes table schema, which has 10 columns. These columns store the information about a candidate including a detailed resume.

click to expand
Figure 17-3: Schema of the Resumes table

Figure 17-4 shows the Users table schema, which has only three columns to store the user ID, password, and email address.

click to expand
Figure 17-4: Schema of the Users table

Applied ADO. NET(c) Building Data-Driven Solutions
Applied ADO.NET: Building Data-Driven Solutions
ISBN: 1590590732
EAN: 2147483647
Year: 2006
Pages: 214

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net