Solved

Database Setup

Posted on 2014-10-28
7
146 Views
Last Modified: 2014-11-12
Hi All,

I'm looking to setup a simple database for my own use in either Access or MS SQL.  I need to know the best way to setup the tables.  Here is the information I will be collecting:

Position
Skills (could be up to 15 items)
Company
Company Contact
Phone Number
Email Address
Description (could be a few paragraphs)



Thanks

Jackson
0
Comment
Question by:Jack_son_
7 Comments
 
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 250 total points
ID: 40410000
If you are after sample schemas then you can refer to microsoft blogs where in you could get scripts ready for use

http://technet.microsoft.com/en-us/library/bb187299(v=sql.80).aspx

If you are after capturing only these

Position
Skills (could be up to 15 items)
Company
Company Contact
Phone Number
Email Address
Description (could be a few paragraphs)

Then Store the Personal Details like Email address,Position,Company in a single table
and the rest like
Company , Company Contact in one table
Person Details, Skills in one more table

vis-a-vis, see how many one-one relationships are present between items and group them in a single table
if there are one-many or many-many relationships then identify the key item which is basis of the relationships and store them in a separate table..
0
 
LVL 8

Assisted Solution

by:johny_bravo1
johny_bravo1 earned 125 total points
ID: 40410007
1. Skills
SkillId int PK
SkillName varchar(200)

2.CompanyDetails
CompanyId int PK
Company varchar(200)
Company Contact varchar(100)
Phone Number varchar(20)
Email Address varchar(80)
Description  varchar(200)

3.CompanySkilla
CompanyID
SkillId
(CompanyId + SkillId Primary key)
0
 

Author Comment

by:Jack_son_
ID: 40415658
ok, thanks; how could I attach a resume?
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 40416297
Store it in a clob column.. Create a column in resume table.. And attach a bfile to corresponding candidate I'd

Table Resume(
Candidate_id number,
Person_id number,
Resume clob)
0
 

Author Comment

by:Jack_son_
ID: 40417383
thanks; I have decided to use MySQL, does this type of clob column exist?
0
 
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 250 total points
ID: 40417941
Not an expert in Mysql but it should be there.. .. Check this link for an illustration of declaring and using clobs in mysql
http://www.herongyang.com/JDBC/MySQL-CLOB-Columns-CREATE-TABLE.html
0
 
LVL 23

Accepted Solution

by:
Eirman earned 125 total points
ID: 40430042
You should be able to do what you want within access itself (no need for MySQL).
Check out "Long Binary Data" and BLOBS

http://bytes.com/topic/access/answers/884328-microsoft-access-file-long-binary-data-field
Access typically displays the text "Long Binary Data" in a field when it contains a BLOB (Binary Large Object). A BLOB can be any type of binary data, and is most commonly a copy of a file, such as a JPEG photo or other Graphic Image. The BLOB field contains a Byte-for-Byte copy of the file, so it can easily be extracted back to the File System resulting in an identical copy of the original file.

======================================================
Rather than including huge amount of data within the database file itself, I think you should consider keeping the resumes in a relative folder. The path to that folder/files can be held in a table record and displayed on a form or report (an icon type hyperlink would look nice). This type of solution is much better (and simpler) than bloating the database and leaving it more vulnerable to corruption.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now