Search
1. Indicate at least two different meanings for each of the following sentences, by including names for object types and reference modes.
a. Pluto is owned by Mickey.
b. Dallas is smaller than Sydney.
1.The CIP will reject a compound transaction if any of its component update operations is inconsistent with the conceptual schema”. True or false?
2.Assuming the conceptual schema is already stored, what are the two main functions of the conceptual information processor?
Write a program to implement a dequeue with the help of a linked list.
Write a program to create a queue that permits insertion at any vacant location at the rear end.
data member named mileage and price. Create its two subclasses
*Car with data members to store ownership cost, warranty (by years), seating capacity and fuel type
(diesel or petrol).
*Bike with data members to store the number of cylinders, number of gears, cooling type(air, liquid
or oil), wheel type(alloys or spokes) and fuel tank size(in inches)
Make another two subclasses Audi and Ford of Car, each having a data member to store the model
type. Next, make two subclasses Bajaj and TVS, each having a data member to store the make-type.
Now, store and print the information of an Audi and a Ford car (i.e. model type, ownership cost,
warranty, seating capacity, fuel type, mileage and price.) Do the same for a Bajaj and a TVS bike.
what are the examples for hardware system requirements?
Entities. Attributes. Customer-
Customer Number, Name, Address, Telephone Number, Payment Number, Installation Number.
Facility-
Facility Number, Employee Number, Equipment Number, Type.
Payment-
Amount, Payment Date, Customer Number, Facility Number, Payment Method.
Installation-
Address, Type, Name, Installation Number, Customer Number, Employee Number.
Equipment-
Inventory Number, Category, Type, Facility Number, Staff Number.
Staff-
Staff Number, Type, Name, Period, Telephone Number, Equipment Number.
Employee-
Employee ID, Designation, Address, Name, Salary, Facility Number, Telephone Number.
1.1.Check whether the provided logical design is normalized. If not, normalize the database by removing the anomalies.
2. Consider the ER diagram in Figure, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints that produced this schema. List and identify entities, attributes, relationships and keys.
1. Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students’ transcripts
a. The university keeps track of each student’s name, student number, Social Security number, current address and phone number, permanent address and phone number, birth date, sex, class (freshman, sophomore, ..., graduate),major department, minor department (if any), and degree program(B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city,state, and ZIP Code of the student’s permanent address and to the student’slast name. Both Social Security number and student number have unique values for each student.
b. Each department is described by a name, department code, office number,office phone number, and college. Both name and code have unique values for each department.
c. Each course has a course name, description, course number, number of semester hours, level, and offering department. The value of the course number is unique for each course
- What is the Functional Requirement?
- What is the Non-Functional Requirement?
- What is the Software System Requirement?
- What is the Hardware System Requirement?
