a instructorid b coursed c taught d currentlyAssigned 6 Then it would be the

A instructorid b coursed c taught d currentlyassigned

This preview shows page 16 - 19 out of 19 pages.

a. instructorid b. coursed c. taught d. currentlyAssigned 6. Then it would be the Student table I would create, which would contain these fields. a. studentid b. firstName c. lastName d. phone e. email f. birthdate g. enrollmentDate h. graduationDate
Birchwood Lane School – Database Proposal for System of Record 17 7. Next, I would create the StudentCourse table which would map the students to the courses, and contain these fields. a. studentid b. courseid c. courseStartDate d. courseEndDate e. taken f. currentlyEnrolled 8. Then I would create the StudentAddress table because a student might have more than one address. It would contain these fields. a. studentid b. streetAddress c. city d. state e. zipCode 9. Then last, I would create the InstructorAddress table, for the same reason as an instructor might have more than one address. It would contain these fields. a. instructorid b. streetAddress c. city d. state e. zipCode
Birchwood Lane School – Database Proposal for System of Record 18 10. Once all the tables are created, we would create the stored procedures needed to insert, update or delete data that was necessary for the application to call. 11. We would also want to define a user that the application will use to connect to the database and make sure the permissions are setup correctly. 12. The last thing we would do is, create indexes to contribute to making the product more efficient. Creating the indexes might take some time to fine-tune as people use the product to make sure we have everything working efficiently.
Birchwood Lane School – Database Proposal for System of Record 19 References Administer Servers with SQL Server Management Studio. (2016). Microsoft . Retrieved from Data Types. (2016). Microsoft . Retrieved from - us/library/ms172424(v=sql.110).aspx Editions and Components of SQL Server 2016. (12/1/2016). Microsoft . Retrieved from Editions and Supported Features for SQL Server 2016. (2016). Microsoft . Retrieved from Scalability and Performance Features. (2016). STARS Campus Solution . Retrieved from Hardware and Software Requirements for Installing SQL Server. (2016). Microsoft . Retrieved from Practical & Powerful School Management Software. (2016). PraxiSchool . Retrieved from SQL Server 2016 Enterprise (per Core). (2016). Creationengine . Retrieved from SQL Server 2016 Standard Edition. (2016). Creationengine . Retrieved from SQL Server pricing. (2016). Microsoft . Retrieved from - server/sql-server-2016-pricing

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture