Reference no: EM131399388
1. Create a table named Faculty to store FacultyID (Primary key), FirstName, LastName, Email, Dateof birth and number of courses taught to date. You should select the appropriate data types andconstraints for the table.
2. Create a table named Courses to store CourseID (Primary key), Discipline Name (e.g. SDEV),Course Number (e.g. 300), Number of Credits (e.g. 3), Year first offered (e.g. 2010) and CourseTitle. You should select the appropriate data types and constraints for the table.
3. Create a table named Faculty Courses to store the Faculty and the Courses they have taught. Youshould design the table based on the Faculty and Courses tables you previously created.
4. Use Insert statements to populate at least 10 faculty records, 5 Course records, and 25FacultyCourses records
5. Use update statements to update all Courses to 4 credits
6. Use update statements to update any Faculty who have taught more than 4 courses to modifythe number to 5 courses taught
7. Delete any Faculty record whose LastName starts with the letter 'Z'
8. Delete any Course record that was first offered in 1999
9. Use select statements to display all records in all 3 tables. Order by the Faculty lastname, andCourse title as appropriate. Note you should use 3 separate select statements to satisfy thisrequirement
10. Use Select statements to display all Faculty who have not taught any courses11. Use Select statements to display all Courses offered before 198412. Use Select and appropriate joins to display all columns from the Faculty and Course tables foreach Faculty and Course in the FacultyCourse table. Note: this will be a 3-table join.
|
Discuss about the managing and prioritizing stakeholders
: The instrumental approach, on the other hand, suggests that the notion of empathy is not necessarily needed for an organization to manage their stakeholders. Instead, an organization should manage their various stakeholder groups to maximize the ..
|
|
Identify the source of the ambiguity
: identify the source of the ambiguity: (1) improper syntax (word order), (2) missing comma, (3) unclear pronoun reference, or (4) grouping of conflicting words.
|
|
Bearing on comparative costs
: Why is it that the pre-trade production points have a bearing on comparative costs under in- creasing-cost conditions but not under conditions of constant costs?
|
|
Compare the two servers with respect to the variation
: Compare the two servers with respect to the approximate centers (locations) of their tip percentage.- Compare the two servers with respect to the variation (spread) among tip percentages.
|
|
Statements to populate at least
: Create a table named Faculty Courses to store the Faculty and the Courses they have taught. Youshould design the table based on the Faculty and Courses tables you previously created. Use Insert statements to populate at least 10 faculty records, 5 ..
|
|
What is your earliest memory of reading
: What kinds of writing/reading have you done in the past - How much have you enjoyed the various kinds of writing/reading you've done and what are particularly vivid memories that you have of reading, writing, or activities that involved them?
|
|
Complete the ethical theories comparison chart
: Over the course of thousands of years, various theories have been offered to explain the best way to determine what is ethical. The search for "good" or correct actions and thoughts has provided several strong approaches that are actively used tod..
|
|
System consists of three identical components
: A system consists of three identical components. In order for the system to perform as intended, all of the components must perform. Each has the same probability of performance. If the system is to have a .92 probability of performing, what is the m..
|
|
Do you think that research supports the validity of effect
: Do you think that research supports the validity of the overjustification effect? Provide specific examples to support your answer. Must be at least 300 words. APA format.
|