Subject :Information Management 1 9:09 60HzG all ll 80%Case Study 1 (Cc-105).pdfCASE STUDY #1 (CC – 105)Instructions: Based from the given data dictionary below, answer the following questions:DATABASE NAME: ENROLLMENTTABLE NAMEATTRIBUTE NAMEРK or FKDATA TYPECHAR(13)VARCHAR(50)VARCHAR(50)YEAR(4)CHAR(13)CHAR(15)CHAR(40)CONTENTSREQUIRED FIELDSTUDENTSTUD_NUMStudent's ID NumberYPKSTUD FNAMEStudent's First NameYSTUD LNAMEStudent's Last NameYYR_ADMITYear AdmittedYCOURSECOURSE_IDCourse IDYPKCOURSE_NAMECourse Name in Abbreviated FormYCourse Major (if any)Subject _IDSubject NameSubject UnitsCOURSE MAJORNSUBJ_IDSUBJ_NAMESUBJECTCHAR(15)VARCHAR(60)CHAR(6)YPKYSUBJ_UNITSY1. How many entities are there within the entire database?2. How many attributes are there for each entity?3. Give at least four (4) constraint within each of the entities.

Entities are the real world objects. Attributes are the characteristics. Constraints are the…

Instructions: Based from the given data dictionary below, answer the following questions: DATABASE NAME: ENROLLMENT TABLE NAME ATTRIBUTE NAME CONTENTS REQUIRED FIELD PK or FK STUD_NUM STUD_FNAME STUD LNAME DATA TYPΕ CHAR(13) VARCHAR(50) VARCHAR(50) YEAR(4) STUDENT Student's ID Number Y PK Student's First Name Y Student's Last Name Y YR_ADMIT Year Admitted Y COURSE COURSE_ID PK CHAR(13) CHAR(15) Course ID Y COURSE_NAME Course Name in Abbreviated Form Y Course Major (if any) Subject _ID Subject Name Subject Units COURSE MAJOR CHAR(40) N SUBJ_ID CHAR(15) VARCHAR(60) SUBJECT Y PK SUBJ_NAME Y SUBJ UNITS CHAR(6) Y 1. How many entities are there within the entire database? 2. How many attributes are there for each entity? 3. Give at least four (4) constraint within each of the entities.

Instructions: Based from the given data dictionary below, answer the following questions: DATABASE NAME: ENROLLMENT TABLE NAME ATTRIBUTE NAME CONTENTS REQUIRED FIELD PK or FK STUD_NUM STUD_FNAME STUD LNAME DATA TYPΕ CHAR(13) VARCHAR(50) VARCHAR(50) YEAR(4) STUDENT Student's ID Number Y PK Student's First Name Y Student's Last Name Y YR_ADMIT Year Admitted Y COURSE COURSE_ID PK CHAR(13) CHAR(15) Course ID Y COURSE_NAME Course Name in Abbreviated Form Y Course Major (if any) Subject _ID Subject Name Subject Units COURSE MAJOR CHAR(40) N SUBJ_ID CHAR(15) VARCHAR(60) SUBJECT Y PK SUBJ_NAME Y SUBJ UNITS CHAR(6) Y 1. How many entities are there within the entire database? 2. How many attributes are there for each entity? 3. Give at least four (4) constraint within each of the entities.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Explain the concept of proactive system management and provide examples of proactive measures organizations can take to optimize their IT systems.
What are some recent technological advances in information technology?
Information technology industrial attachment report
Describe the fundamental objectives of system management within an organization.
A(n) oversees the operation of a large information processing facility. field supervisor information systems manager computer operations manager network administrator
Explain the concept of ITIL (Information Technology Infrastructure Library) and its role in effective system management.