Itsw 2337 advance database at nctc class project 1

This preview shows page 7 - 11 out of 12 pages.

ITSW 2337 - Advance Database at NCTC Class Project #1 - Task
3. SQL Query A. Provide a list of full names by their birthday ITSW 2337 - Advance Database at NCTC Class Project #1 - Task
B. Provide a list of department managers listed by department name
Page 8
ITSW 2337 - Advance Database at NCTC Class Project #1 - Task C. Provide a list of departments that have employees with salaries > $80K
D. Provide a list of those employees with less than 1 yr employment
Page 9
Page 10 (continued) 4. Before this database was developed, the administrator had to design and list an implementation plan by taking various steps. See the steps listed for task #4 below and place them in the correct order of appropriate sequence of events: Textbook Reference: Page 418 Normalize the conceptual model. Obtain a general description of company operations. Load the database. Fine tune the database. Create a description of each system process. Test the system. Draw a data flow diagram and system flowcharts. Create a conceptual model, using ER diagrams. Create the application programs. Interview the department manager. Create the file (table) structures. Create the file (index) structures. Interview the store manager. Install DBMS ITSW 2337 - Advance Database at NCTC Class Project #1 - Task 1. Interview the store manager. 2. Interview the department manager.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture