Additional entities along with their attributes that TAL should include in its database to store information about its employee as well.

Question

Want to see the full answer?

Answer 1

Question

Chapter 1, Problem 12TDE

To determine

Additional entities along with their attributes that TAL should include in its database to store information about its employee as well.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Joan Yancey has been asked to create a database for her company, Yancey Shipping. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. She has determined that she needs the following tables and fields in her database:(Table 1) Employee Information:Fields - Last Name, First Name, Street Address, City, State, Zip Code, Social Security Number, Phone Number, Hourly Pay Rate, and Project Number (Table 2) Project Information:Fields - Project Number, Project Name, Project Leader, Project Location, Total Hours, and Actual Completion Date What data type should Joan Yancey use for the Actual Completion Date field and why?

Based on the following ER model and business rules, write an SQL statement to create COURSE and COURSE_PREREQ table. Be sure to implement all related data integrity constraint. For each column, use the data type as you think appropriate. Business rule • A course may have more than one prerequisites. The prerequisite courses may have their own prerequisite courses (more than one). COUSE entity • CourseNo is a UID (unique identifier). • Credit hours should be greater than 0 and less than 7. COURSE_PREREQ entity • UID is the composite of CourseNo and CourseNo (i.e., prerequisite courseNo). COURSE COURSE_PREREQ CourseNo: UID Title Description CourseNo: LCourseNo: UID CreditHours

using data from tal distributors database , define a view named toplevelcust. it consists of the number, name, address , balance , and credit limit of all customers with credit limits taht are greater than or equal to $10,000