public AddRelationForm()
{
InitializeComponent();
//NEW ATTRIBUTE TYPE COMBO BOX
newAttributeTypeComboBox.Items.Add("varchar");
newAttributeTypeComboBox.Items.Add("integer");
newAttributeTypeComboBox.Items.Add("date");
newAttributeTypeComboBox.Items.Add("real");
newRelation = new Relation();
attributeDict = new Dictionary<string, AttributeType>();
primaryKey = string.Empty;
}
private void CreateInputs()
{
Relation r1 = new Relation();
r1.relationName = "EMPLOYEE";
r1.primaryKeys.Add("SSN");
r1.attributeDict.Add("FNAME", AttributeType.varchar);
r1.attributeDict.Add("LNAME", AttributeType.varchar);
r1.attributeDict.Add("SSN", AttributeType.varchar);
r1.attributeDict.Add("DATE_OF_BIRTH", AttributeType.varchar);
r1.attributeDict.Add("ADDRESS", AttributeType.varchar);
r1.attributeDict.Add("DNUMBER", AttributeType.integer);
r1.attributeDict.Add("SALARY", AttributeType.integer);
r1.attributeDict.Add("SUPER_SSN", AttributeType.varchar);
Relation r2 = new Relation();
r2.relationName = "DEPARTMENT";
r2.primaryKeys.Add("DNUMBER");
r2.attributeDict.Add("DNAME", AttributeType.varchar);
r2.attributeDict.Add("DNUMBER", AttributeType.integer);
r2.attributeDict.Add("MGR_SSN", AttributeType.varchar);
r2.attributeDict.Add("MGR_START_DATE", AttributeType.date);
Relation r3 = new Relation();
r3.relationName = "DEPT_LOCATIONS";
r3.primaryKeys.Add("DNUMBER");
r3.primaryKeys.Add("DLOCATION");
r3.attributeDict.Add("DNUMBER", AttributeType.integer);
r3.attributeDict.Add("DLOCATION", AttributeType.integer);
Relation r4 = new Relation();
r4.relationName = "PROJECT";
r4.primaryKeys.Add("PNUMBER");
r4.attributeDict.Add("PNAME", AttributeType.varchar);
r4.attributeDict.Add("PNUMBER", AttributeType.integer);
r4.attributeDict.Add("PLOCATION", AttributeType.varchar);
r4.attributeDict.Add("DNUMBER", AttributeType.integer);
Relation r5 = new Relation();
r5.relationName = "WORKS_ON";
r5.primaryKeys.Add("SSN");
r5.primaryKeys.Add("PNUMBER");
r5.attributeDict.Add("SSN", AttributeType.varchar);
r5.attributeDict.Add("PNUMBER", AttributeType.integer);
r5.attributeDict.Add("HOURS", AttributeType.integer);
Relation r6 = new Relation();
r6.relationName = "DEPENDENT";
r6.primaryKeys.Add("SSN");
r6.primaryKeys.Add("DEPENDENT_NAME");
r6.attributeDict.Add("SSN", AttributeType.varchar);
r6.attributeDict.Add("DEPENDENT_NAME", AttributeType.varchar);
r6.attributeDict.Add("SEX", AttributeType.varchar);
r6.attributeDict.Add("BIRTHDAY", AttributeType.date);
r6.attributeDict.Add("RELATION", AttributeType.varchar);
_masterListRelations.Add(r1);
_masterListRelations.Add(r2);
_masterListRelations.Add(r3);
_masterListRelations.Add(r4);
_masterListRelations.Add(r5);
_masterListRelations.Add(r6);
}