This assignment will be graded out of 40 points. Based on these assumptions and your understanding of the real-world scenario being modeled, specify an appropriate set of referential integrity constraints for this schema. A references S . B ,'' where R . A and S .
B are attributes.
Use the SQL syntax for constraints described in the course notes and in class. A must be at least twice the value of attribute R . For each of the following constraints, specify the constraint in SQL using the lowest-numbered constraint type from Problem 2 that guarantees the constraint cannot become violated. No person is his or her own manager. No companies are located in the city of Atherton.