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); }