Databases | SQL | Oracle | MS Access Answers

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.

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

1. What is the Functional Requirement?
2. What is the Non-Functional Requirement?
3. What is the Software System Requirement?
4. What is the Hardware System Requirement?

Instillation Management Form

Installation ID| Installation Type| Installation Name and Address| Customer| Equipment| Types of Staff Required| Period of Staff assignment.

Polly Pipe is focused in placing aquariums at business customers. Customers can request several installations, but each installation is tailor-made for a specific customer. Facilities are classified by type. One or more employees are assigned to each facility. Because these facilities are often very large, they can include carpenters and masons as well as water installers. The facilities use equipment such as aquariums, air pumps and thermostats. There can be multiple computers in a facility.

Staff Management Record

Staff Number| Name| Type

............................................................................................................

Equipment Type Table

Type| Equipment

Identify the user and system requirements to design a database for the above scenario and design a relational database system using conceptual design (ER Model).