extend the design to accommodate degree programs, computer science homework help

User Generated

cuvyylgba0625

Computer Science

Description

Using your Week 1 IP as a starting point, extend the design to accommodate degree programs. The new design should incorporate the following functionalities:

  • A degree has a name and description.
  • What degree is the student working towards? A student can only work on one degree at a time.
  • What classes are necessary to obtain a specific degree?
  • Provide the DDL script to add the tables for the new design changes. Include an updated diagram that shows all the tables in the system.
  • Write the DML script to insert 3 test records in each of the tables in the system. This data will be necessary to write the queries in the next assignment.
  • Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Upload your document to the Submitted Tasks section.

Please submit your assignment.


Unformatted Attachment Preview

Cebu Technological University (CTU) data management. Structured Query Language for Data Management (CS 362 – 1603A – 02) Assignment On DML (Select) and Procedures Submitted To Instructor Stephen Lappe Data Management Submitted By Phillip Isiah Houston Sr. Registration No: 18103918 Semester: Summer 2016 Colorado Technical University 1 Cebu Technological University (CTU) data management. TABLES OF CONTENTS. WEEK 1 IP- DATABASE DESIGN AND DDL ....................................................................... 3 BUSINESS RULES & ENTITY TABLES ............................................................................................ 3 ENTITY TABLES:................................................................... ERROR! BOOKMARK NOT DEFINED. SQL CODE: ........................................................................ ERROR! BOOKMARK NOT DEFINED. SCREENSHOTS: ............................................................................................................................. 7 WEEK 2 IP – SECURITY AND DML ..................................................................................... 20 TASK 1 ........................................................................................................................................ 20 TASK 2 ........................................................................................................................................ 22 TASK 3 ........................................................................................................................................ 23 TASK 4 ........................................................................................................................................ 24 TASK 5 ....................................................................................................................................... 25 WEEK 3 IP- DML (SELECT) AND PROCEDURES ............................................................. 27 TASK 1 ........................................................................................................................................ 27 TASK 2 ........................................................................................................................................ 29 TASK 3 ........................................................................................................................................ 30 TASK 4 ....................................................................................................................................... 31 TASK 5 ........................................................................................................................................ 32 WEEK 4 IP – ARCHITECTURE, INDEXES........... ERROR! BOOKMARK NOT DEFINED. STEP 1: CREATE TABLE [DEGREES] ................................. ERROR! BOOKMARK NOT DEFINED. STEP 2: RE-CREATE ‘CLASSES’ TABLE TO ADD ‘DEGREEID’ COLUMN AND INSERT 6 CLASSES ............................................................................................. ERROR! BOOKMARK NOT DEFINED. STEP 3: ALTER TABLE [STUDENTS].................................. ERROR! BOOKMARK NOT DEFINED. STEP 5: DML SCRIPT TO INSERT INTO THE ‘STUDENTS’ TABLE ‘DEGREEID’ DATA ...... ERROR! BOOKMARK NOT DEFINED. STEP 6: DISPLAY ERD ......................................................... ERROR! BOOKMARK NOT DEFINED. WEEK 5 IP – VIEWS, TRANSACTIONS, TESTING AND PERFORMANCE ....... ERROR! BOOKMARK NOT DEFINED. REFERENCES ............................................................................................................................ 35 2 Cebu Technological University (CTU) data management. Week 1 IP - Database Design and DDL I was assigned the task of developing a university database of my choice. Among the universities I researched on, Cebu Technological University emerged to be the University of my Choice. The database is to be used in storing data and information that is personal and confidential. The database should also provide both back-end and front-end architecture for web application that has an interactive User Interface which is used by the HR department of this university. Based on the nature of the data to be installed, server security and server maintenance tools that are to be left to the university after successful testing and deployment of this application I have decided to use Microsoft SQL Server Management Studio since it satisfies application requirement. After the initial meeting with my client, the requirements were determined and scoped before creating the database. This section contains business rules along with the entity tables developed during the initial meeting with the clients and copies of SQL code that are used to create database and Entity Relationship Diagram (ERD). Business Rules & Entity Tables Business Rules:  A student has a name, a birth date, and gender.  You must track the date the student started at the university and his or her current GPA, as well as be able to inactivate him or her without deleting information.  For advising purposes, store the student's background/bio information. This is like a little story.  An advisor has a name and an e-mail address.  Students are assigned to one advisor, but one advisor may service multiple students.  A class has a class code, name, and description.  You need to indicate the specific classes a student is taking/has taken at the university. Track the date the student started a specific class and the grade earned in that class.  Each class that a student takes has 4 assignments. Each assignment is worth 100 points. 3 Cebu Technological University (CTU) data management. Entity Tables: SQL codes for creating Database CREATE DATABASE [Cebu_CTU] CONTAINMENT = NONE ON PRIMARY 4 Cebu Technological University (CTU) data management. ( NAME = N'Cebu_CTU', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\DATA\Cebu_CTU.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB ) LOG ON ( NAME = N'Cebu_CTU_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\DATA\Cebu_CTU_log.ldf' , SIZE = 1024KB , FILEGROWTH = 01% ) GO ALTER DATABASE [Cebu_CTU] SET COMPATIBILITY_LEVEL = 110 GO ALTER DATABASE [Cebu_CTU] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [Cebu_CTU] SET ANSI_NULLS OFF GO ALTER DATABASE [Cebu_CTU] SET ANSI_PADDING OFF GO ALTER DATABASE [Cebu_CTU] SET ANSI_WARNINGS OFF GO ALTER DATABASE [Cebu_CTU] SET ARITHABORT OFF GO ALTER DATABASE [Cebu_CTU] SET AUTO_CLOSE OFF GO ALTER DATABASE [Cebu_CTU] SET AUTO_SHRINK OFF GO ALTER DATABASE [Cebu_CTU] SET AUTO_CREATE_STATISTICS ON(INCREMENTAL = OFF) GO ALTER DATABASE [Cebu_CTU] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [Cebu_CTU] SET CURSOR_CLOSE_ON_COMMIT OFF GO 5 Cebu Technological University (CTU) data management. ALTER DATABASE [Cebu_CTU] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [Cebu_CTU] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [Cebu_CTU] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [Cebu_CTU] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [Cebu_CTU] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [Cebu_CTU] SET DISABLE_BROKER GO ALTER DATABASE [Cebu_CTU] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [Cebu_CTU] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [Cebu_CTU] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [Cebu_CTU] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [Cebu_CTU] SET READ_WRITE GO ALTER DATABASE [Cebu_CTU] SET RECOVERY SIMPLE GO ALTER DATABASE [Cebu_CTU] SET MULTI_USER GO ALTER DATABASE [Cebu_CTU] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [Cebu_CTU] SET TARGET_RECOVERY_TIME = 60 SECONDS GO ALTER DATABASE [Cebu_CTU] SET DELAYED_DURABILITY = DISABLED 6 Cebu Technological University (CTU) data management. GO USE [Cebu_CTU] GO IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [Cebu_CTU] MODIFY FILEGROUP [PRIMARY] DEFAULT GO Screenshot after successfully creating Cebu_CTU Database: 7 Cebu Technological University (CTU) data management. Create Students Table: CREATE TABLE [dbo].[Students] ( [StudentID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL, [FirstName] [varchar](200) NOT NULL, [LastName] [varchar](200) NOT NULL, [BirthDate] [date] NOT NULL, [Gender] [char](1) NOT NULL, [StartDate] [date] NOT NULL, [GPA] [numeric](4, 0) NOT NULL, [IsActive] [varchar](20) NOT NULL, [Bio] [varchar](200) NOT NULL, [AdvisorID] [int] NOT NULL, ) Screenshot after successfully creating Students Table: 8 Cebu Technological University (CTU) data management. Create Advisors Table: CREATE TABLE [dbo].[Advisors] ( [AdvisorID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL, [FirstName] [varchar](50) NOT NULL, [LastName] [varchar](50) NOT NULL, [EmailAddr] [varchar](150) NOT NULL, ) 9 Cebu Technological University (CTU) data management. Screenshot after successfully creating Advisors Table: Create Classes Table: CREATE TABLE [dbo].[Classes] ( 10 Cebu Technological University (CTU) data management. [ClassID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL, [ClassCode] [varchar](20) NOT NULL, [ClassName] [varchar](50) NOT NULL, [Description] [varchar](500) NOT NULL, ) Screenshot after successfully creating Classes Table: Create Students_Classes Table: USE Cebu_CTU 11 Cebu Technological University (CTU) data management. CREATE TABLE Students_Classes (StudentClassID INT IDENTITY PRIMARY KEY NOT NULL, StudentID INT NOT NULL, ClassID INT NOT NULL, StartDate DATE NOT NULL, Assignment1 NUMERIC(4,3) NULL, Assignment2 NUMERIC(4,3) NULL, Assignment3 NUMERIC(4,3), Assignment4 NUMERIC(4,3) NULL, ClassGPA NUMERIC(4,2) NULL, ) Screenshot after successfully creating Students_Classes Table: Create an additional table named Degrees: CREATE TABLE [dbo].[Degrees] ( 12 Cebu Technological University (CTU) data management. [DegreeID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL, [DegreeCode] [varchar](20) NOT NULL, [DegreeName] [varchar](50) NOT NULL, [Description] [varchar](500) NOT NULL, ) Screenshot after successfully creating Degrees Table: Recreate Students Table and make ‘AdvisorID’ and ‘DegreeID’ FOREIGN KEYS, and make ‘StudentID’ a FOREIGN KEY on the Students_Classes table. 13 Cebu Technological University (CTU) data management. CREATE TABLE Students (StudentID INT IDENTITY PRIMARY KEY NOT NULL, FirstName VARCHAR(40) NOT NULL, LastName VARCHAR(40) NOT NULL, BirthDate DATE NOT NULL, Gender CHAR(1) NOT NULL, StartDate DATE, GPA DECIMAL(4,2), IsActive CHAR(3) NOT NULL, Bio VARCHAR(2000), AdvisorID [int], DegreeID [int] NOT NULL, ) ALTER TABLE Students ADD FOREIGN KEY (AdvisorID) REFERENCES Advisors ([AdvisorID]) GO ALTER TABLE Students ADD FOREIGN KEY ([DegreeID]) REFERENCES Degrees ([DegreeID]) Screenshot after successfully creating recreated Students Table: 14 Cebu Technological University (CTU) data management. Alter [Students_Classes] Table to assign Foreign Keys StudentID and ClassID to it, which are PRIMARY KEYS on Students and Classes table respectively. After establishing all the relationships, we will now move ahead to creating the ERD. 15 Cebu Technological University (CTU) data management. SQL Code: ALTER TABLE Students_Classes ADD FOREIGN KEY (StudentID) REFERENCES Students([StudentID]) GO ALTER TABLE Students_Classes ADD FOREIGN KEY ([ClassID]) REFERENCES Classes ([ClassID]) Screenshot after successful execution of the SQL codes above. 16 Cebu Technological University (CTU) data management. After establishing the relationships above, where ERD can now be created, we now add New DML script which adds constraints for GPA, Gender and assignment1 to Assingment4 USE Cebu_CTU ALTER TABLE Students ADD CONSTRAINT checkkGPA CHECK (GPA BETWEEN 0.00 and 4.00); ALTER TABLE Students ADD CONSTRAINT checkGender CHECK (Gender IN ('M', 'F')); ALTER TABLE Students_Classes ADD CONSTRAINT checkAssignment1 CHECK (Assignment1 BETWEEN 0 AND 100); ALTER TABLE Students_Classes ADD CONSTRAINT checkAssignment2 CHECK (Assignment2 BETWEEN 0 AND 100); ALTER TABLE Students_Classes ADD CONSTRAINT checkAssignment3 CHECK (Assignment3 BETWEEN 0 AND 100); ALTER TABLE Students_Classes ADD CONSTRAINT checkAssignment4 CHECK (Assignment4 BETWEEN 17 Cebu Technological University (CTU) data management. 0 AND 100); Screenshot after successfully executing the above codes: 18 Cebu Technological University (CTU) data management. ERD Screenshot for the new Database. 19 Cebu Technological University (CTU) data management. Week 2 IP – Security and DML Having carried out the Week1 assignments that contained creation of the four tables i.e. Students, Classes, Advisors and the Students_Classes tables, Week two tasks will involve inserting, deleting and updating data. Insert statement is performed in two ways i.e. i. ii. Positional insert which inserts ordered values in the rows in the order of table columns. A named column which inserts names in the exact column where each value is inserted into a new row. According to Fehily (2008), the importance of practicing to use named-column is that it allows enables you execute your SQL code in case the table’s code are reordered or incase a new column is added. Some SQL codes includes INSERT VALUES which specify column values, INSERT SELECT which performs the function of inserting row from another table. Though not all DBMS requires one to use INTO keyword after every INSERT statement; one should practice using it for portability capabilities. On the other hand, the UPDATE statement is used the values of the data stored in the table rows. Failure to user the WHERE clause when running this query updates all the rows of the table other than the target row(s). One should also note that the new value must be of the same data type as its column. The third statement is the DELETE statement which is used to delete one column, more than one column, entire row or all the table rows. Fehily (2008) also argues that it requires one to be cautious when executing this query since failure to add the WHERE clause can lead to deleting all the rows of the table. Task 1 The first task involved inserting four rows into the Classes table. Below is the SQL code for inserting the rows. INSERT INTO [Cebu_CTU].[DBO].[Classes] ( [ClassCode], [ClassName], [Description] ) VALUES 20 Cebu Technological University (CTU) data management. (‘ACCT306’, ‘Accounting 1', ‘This course introduces accounting concepts and explores the accounting environment. It covers the basic structure of accounting, how to maintain accounts, use account balances to prepare financial statements, and complete the accounting cycle. It also introduces the concept of internal control and how to account for assets.’), ( 'CS362', 'Structured Query Language for Data Management', 'This course gives complete coverage of SQL, with an emphasis on storage, retrieval, and manipulation of data.'), (‘ENG115’, ‘English Composition', ‘In this course, students focus on developing writing skills through practice and revision. Students will examine expository, critical, and persuasive essay techniques.'), (‘FIN322’, ‘Investments’, ‘This course focuses on investments and investment strategies. Various investment vehicles such as stocks, bonds, and commodities are examined. Students will explore the principles of security analysis and valuation.') Screenshot after successfully executing the above codes: 21 Cebu Technological University (CTU) data management. Task 2 This second task involves inserting for rows into the Advisors table. Below is the SQL code for inserting records into Advisors table. INSERT INTO [dbo].[Advisors] ( [FirstName], [LastName], [EmailAddr] ) VALUES ( 'Fred', 'Stone', 'fred@college.edu' ), ( 'Bob', 'Gordon', 'bob@college.edu' ), ( 'Jack', 'Simpson', 'jack@college.edu') Screenshot after successfully executing the above codes: 22 Cebu Technological University (CTU) data management. Task 3 In the third task, we inserted four rows into the Students table. 23 Cebu Technological University (CTU) data management. Below is the SQL code I used to insert the given data into the Students table. INSERT INTO [dbo].[Students] ( [FirstName], [LastName], [BirthDate], [Gender], [StartDate], [GPA], [IsActive], [Bio], [AdvisorID] ) VALUES ( 'Craig', 'Franklin', '1970-03-15', 'm', '2010-05-30', 3.10, 'Yes', '', 3 ), ( 'Harriet', 'Smith', '1982-04-15', 'f', '2010-05-30', 3.22, 'Yes', '', 1 ), ( 'George', 'David', '1984-11-05', 'm', '2010-10-01', 0.00, 'Yes', '', 3 ), ( 'Ben', 'Jefferson', '1976-09-25', 'm', '2009-02-21', 1.80, 'No', 'The student has gone on temporary leave to pursue other opportunities but plans on returning in 1 year.', 3 ) Screenshot after successfully executing the above codes: Task 4 The fourth task involves deleting course named Investments from the Classes table. Below is the SQL code is used for task4. 24 Cebu Technological University (CTU) data management. DELETE FROM Classes WHERE ClassName = 'Investments'; Screenshot after successfully executing the above codes Task 5 This was the final task which involved updating two columns. That is Harriet Smith’s birthdate and GPA to April 25, 1982 and 3.25 respectively. 25 Cebu Technological University (CTU) data management. The SQL code for task 5 is: UPDATE Students SET BirthDate = '1982-04-25', GPA = 3.25 WHERE StudentID = '2'; Screenshot after successfully executing the above codes 26 Cebu Technological University (CTU) data management. Week 3 IP - DML (Select) and Procedures Week 2 IP contains seven task that involves retrieval of data using the SELECT FROM statements. SELECT clause is used to define which column will be displayed while the FROM determines the table to which the columns belong. AS clause can also be used in case one wants to create an aliases column. Other clauses associated with this clause includes ORDER BY, AND, OR, JOIN and GROUP BY clause. The JOIN clauses are of two types; Implicit and the explicit join. The commonly used one is the implicit JOIN though one may not even realize he/she is using it since it is not a must to include the JOIN in it; it implies when one is querying two or more tables. Task 1 This task involves writing a query that listing all active males students assigned to Advisors 1 or 3. In this task, we will query the Students table records/columns to list all the details of the students who satisfies all the following: Must be a Male student, Must be active and must be assigned to either Advisor 1 or 3. To join the two tables I.e. Advisors and Students table through Student.AdvisorID and Advisor.AdvisorId, we use Implicit JOIN with the WHERE clause. Below is the SQL codes that performs all the above task. SELECT * FROM Cebu_CTU.dbo.Students WHERE Gender = 'm' AND IsActive = 'yes' AND AdvisorID IN (1,3) 27 Cebu Technological University (CTU) data management. Screenshot after successfully executing the above codes: 28 Cebu Technological University (CTU) data management. Task 2 The second task involves displaying all the students whose without biography. The SQL code associated with this task is: SELECT * FROM Cebu_CTU.dbo.Students WHERE Bio='' Screenshot after successfully executing the above codes: 29 Cebu Technological University (CTU) data management. Task 3 The third task involved displaying all classes are in the English department. In this task I used a wild card (%) just after ‘G’ in the word “ENGLISH”. The SQL code for task 3 is: SELECT ClassCode, ClassName FROM Cebu_CTU.dbo.Classes WHERE ClassName LIKE 'ENG%' Screenshot after successfully executing the above codes: 30 Cebu Technological University (CTU) data management. Task 4 This task involves displaying all the students and their advisors. The results are sorted by Advisor’s name then student’s name ascending. The two tables i.e. Students and Advisors are implicitly joined by the Students.AdvisorID and Advisors.AdvisorsID. Below is the SQL code for task 4: SELECT A.AdvisorID, A.FirstName, A.LastName, S.StudentID, S.FirstName, S.LastName,BirthDate, Gender, GPA FROM Cebu_CTU.dbo.Students S, Cebu_CTU.dbo.Advisors A WHERE S.AdvisorID = A.AdvisorID ORDER BY A.LastName, S.LastName ASC; Screenshot after successfully executing the above codes: 31 Cebu Technological University (CTU) data management. Task 5 This task involved calculating the number of students who were born in 1980s. The SQL code associated with task5 is: SELECT COUNT (StudentID) as Students_born_in_the_80s FROM Students WHERE BirthDate between '1980-01-1' AND '1989-12-31'; Screenshot after successfully executing the above codes: 32 Cebu Technological University (CTU) data management. Task 6 This task involves determining the average GPA by gender. Below is the SQL Code for task6: SELECT Gender, AVG(GPA) as Average_GPA_By_Gender from Students Group by Gender Screenshot after successfully executing the above codes: 33 Cebu Technological University (CTU) data management. Task 7 This task involves displaying all the advisors and the number of active students assigned to each advisor filtered by advisors with more than student. Below is the SQL code for task 7: SELECT Advisors.FirstName, Advisors.LastName, COUNT (Advisors.AdvisorID) AS Total_Active_Students FROM Cebu_CTU.dbo.Students, Cebu_CTU.dbo.Advisors WHERE Advisors.AdvisorID = Students.AdvisorID AND Students.IsActive = 'yes' GROUP BY Advisors.FirstName, Advisors.LastName HAVING COUNT (Students.StudentID) > '1'; Screenshot after successfully executing the above codes: 34 Cebu Technological University (CTU) data management. References 1. Visual QuickStart Guide SQL (Fehily C,2008). 35
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Cebu Technological University (CTU) data management.
Structured Query Language for Data Management (CS 362 – 1603A – 02)

Assignment
On
DML (Select) and Procedures

Submitted
To
Instructor Stephen Lappe
Data Management

Submitted
By
Phillip Isiah Houston Sr.
Registration No: 18103918
Semester: Summer 2016

Colorado Technical University

1

Cebu Technological University (CTU) data management.
TABLES OF CONTENTS.
WEEK 1 IP- DATABASE DESIGN AND DDL........................................................................ 3
BUSINESS RULES & ENTITY TABLES ............................................................................................ 3
ENTITY TABLES:................................................................... ERROR! BOOKMARK NOT DEFINED.
SQL CODE:......................................................................... ERROR! BOOKMARK NOT DEFINED.
SCREENSHOTS: ............................................................................................................................. 7
WEEK 2 IP – SECURITY AND DML ..................................................................................... 20
TASK 1 ........................................................................................................................................ 21
TASK 2 ........................................................................................................................................ 22
TASK 3 ........................................................................................................................................ 23
TASK 4 ........................................................................................................................................ 24
TASK

5 ....................................................................................................................................... 25

WEEK 3 IP- DML (SELECT) AND PROCEDURES............................................................. 27
TASK 1 ........................................................................................................................................ 27
TASK 2 ........................................................................................................................................ 29
TASK 3 ........................................................................................................................................ 30
TASK

4 ....................................................................................................................................... 31

TASK 5 ........................................................................................................................................ 32

WEEK 4 IP – ARCHITECTURE, INDEXES.......................................................................... 35
STEP 1: CREATE TABLE [DEGREES]................................................................................... 35
STEP 2: RE-CREATE ‘CLASSES’ TABLE TO ADD ‘DEGREEID’ COLUMN..................................... 36
STEP 3: DML SCRIPT TO INSERT 3 TEST RECORDS IN [DEGREES] TABLE…………………...…36
STEP 4: ALTER TABLE [STUDENTS]........................................................................................ 41
STEP 5: DML SCRIPT TO INSERT INTO THE ‘STUDENTS’ TABLE ‘DEGREEID’ DATA ............... 42
STEP 6: DML SCRIPT TO SHOW WHAT DEGREE EACH STUDENT IS PURSUING...... 44
STEP 6: DISPLAY ERD ............................................................................................................... 44
WEEK 5 IP – VIEWS, TRANSACTIONS, TESTING AND PERFORMANCE...... ERROR!
BOOKMARK NOT DEFINED.
REFERENCES............................................................................................................................ 35
2

Cebu Technological University (CTU) data management.

Week 1 IP - Database Design and DDL
I was assigned the task of developing a university database of my choice. Among the universities
I researched on, Cebu Technological University emerged to be the University of my Choice. The
database is to be used in storing data and information that is personal and confidential. The
database should also provide both back-end and front-end architecture for web application that
has an interactive User Interface which is used by the HR department of this university. Based on
the nature of the data to be installed, server security and server maintenance tools that are to be
left to the university after successful testing and deployment of this application I have decided to
use Microsoft SQL Server Management Studio since it satisfies application requirement. After
the initial meeting with my client, the requirements were determined and scoped before creating
the database. This section contains business rules along with the entity tables developed during
the initial meeting with the clients and copies of SQL code that are used to create database and
Entity Relationship Diagram (ERD).
Business Rules & Entity Tables
Business Rules:


A student has a name, a birth date, and gender.



You must track the date the student started at the university and his or her current GPA,
as well as be able to inactivate him or her without deleting information.



For advising purposes, store the student's background/bio information. This is like a little
story.



An advisor has a name and an e-mail address.



Students are assigned to one advisor, but one advisor may service multiple students.



A class has a class code, name, and description.



You need to indicate the specific classes a student is taking/has taken at the university.
Track the date the student started a specific class and the grade earned in that class.



Each class that a student takes has 4 assignments. Each assignment is worth 100 points.

3

Cebu Technological University (CTU) data management.

E...


Anonymous
Great! 10/10 would recommend using Studypool to help you study.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags