Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside
supertypes notation, as specified by your instructor: An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules:
1 answer:
Answer:
Explanation:
To develop the model for Creating the supertype/subtype relationship three diffrent types of notation is given bellow accrdig to the diagram attached.
1.Traditional EER (Enhance Entity-Relational) notation
2.Microsoft Visio notation
3.Subtypes Inside supertype note
<em><u>Traditional EER(Enhance Entity-Relational)notation for the international school of technology diagram is attached bellow</u></em>
The diagram consist of the following entity
Room Supertype
Media Entity Type
COURSE entity type
Section weak entity type
Schedule associatiative entity type
<u><em>Microsoft Visio Notation for the international school of technology is ashown in the diagram bellow.</em></u>
The diagram consist of the following entity
Room Supertype
Media Entity Type
Computer entity type
Instructor entity type
Time slot entity type
<u><em>Subtype Inside Supertype note Notation for the international school of technology is shown in the diagram bellow.</em></u>
The diagram consist of the following entity
Room Supertype
Media Entity Type
Computer entity type
Instructor entity type
Time slot entity type
You might be interested in
Answer:
The scripts are:
1. SELECT * FROM planes
2. UPDATE planes SET YEAR = 2013 WHERE year IS NULL
3. INSERT INTO planes (Tailnum, Year, type, Manufacturer, Model, Engines, Seats) VALUES ('N15501',2013,'Fixed wing single engine', 'BOEING', 'A222-101',3,100,NULL)
4. DELETE FROM planes WHERE Tailnum = 'N15501'
Explanation:
1. SELECT * FROM planes
To select all from a table, use <em>select * from [table-name]. </em>In this case, the table name is planes
2. UPDATE YEAR = 2013 WHERE year IS NULL
To do this, we use the update query which is as follows:
<em>UPDATE [table-name] SET [column-name]= [value] WHERE [column] IS NULL</em>
So: the above query will update all YEAR column whose value is NULL to 2014
3. INSERT INTO planes (Tailnum, Year, type, Manufacturer, Model, Engines, Seats) VALUES ('N15501',2013,'Fixed wing single engine', 'BOEING', 'A222-101',3,100,NULL)
To insert is very straight foward.
The syntax is:
INSERT INTO [table-name] (column names) VALUES (values)
4. DELETE FROM planes WHERE Tailnum = 'N15501'
To do this, we use the update query which is as follows:
<em>DELETE FROM [table-name] WHERE [column] = [value]</em>
So: The above query will delete the entry in (3) above