relationships in ERD For each entity name the foreign key, cardinality and busin
ID: 3592520 • Letter: R
Question
relationships in ERD
For each entity name the foreign key, cardinality and business rules.
GRADE TYPE GRADE TYFE_CODE (PK) CHAR(2) GRADE CONVERSION LETTER GRADE (PK) VARCHAF2(2) NOT NULL NLMER(3,2) NOT NLL NUMBERI3.0) NOT NULL NUNBERI3,0) NOT NULL VARCHAR2(30) NOT NULL NOT NULL NOT NULL VARCHAR2(50) NOT NULL VARCHAR2(30) NOT NULL NOT NULL VARCHAR2(30) NOT NULL NOT NULL GRADE POINT MAX GRA DE MN GRADE CREATED BY CREATED_DATE MODIFIED BY MODIFIED DATE DATE CREATED DATE DATE DATE VARCHARz(30) NOT NULL NOT NULL MODIFIED DATE DATE GRTW GRTYP FK GRADE STUDENT ID (PK) (FK) SECTION ID (PK)(FK) GRADE_TYPE CODE (PK FK) CHAF2) GRADE TYPE WEIGHT NUMBER(8,0) NOT NULL NUMBER(8,0) NOT NULL NUMBER 8,0 NOT NULL SECTION D(PK)(FK) GRADE_TYPE CODE(PKNFK) CHARI2) NUMBER PER SECTIO FERCENT OF FINAL_GRADE NUMBER3,0) NOT NULL DROP LOWEST CREATEDBY CREATED DATE MODIFBD BY MODIFED DATE NOT NULL NOT NULL GR GRTW F NUMBER3,0 NOT NULL GRADECODE 00CURRENCE (PK) NUMBER(38,0) NOT NILL NUMBER(3,0) NOT NULL VARCHAR2(2000) NULL VARCHAR2(30) NOT NILL NOT NULL VARCHAR2(30) NOT NULL NOT NULL NUMERIC GRADE CHARI1 VARCHAR2130) NOT NULL DATE VARCHAR230) NOT NULL DATE NOT NULL CREATED BY CREATED DATE MODIFIED BY MODIFIBD DATE NOT NULL DATE NOT NULL DATEExplanation / Answer
Identify the entities. The first step in making an ERD is to identify all of the entities you will use. An entity is nothing more than a rectangle with a description of something that your system stores information about. This could be a customer, a manager, an invoice, a schedule, etc. Draw a rectangle for each entity you can think of on your page. Keep them spaced out a bit.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.