Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Draw an object-oriented model for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots. From the requirements for this database, the following information was collected. Each airplane has a registration number [Reg#], is of a particular plane type [OF-TYPE], and is stored in a particular hangar [STORED-IN]. Each plane type has a model number [Model], a capacity [Capacity], and a weight [Weight]. Each hangar has a number [Number], a capacity [Capacity], and a location [Location]. The database also keeps track of the owners of each plane [OWNS] and the employees who have maintained the plane [MAINTAIN]. Each relationship instance in OWNS relates an airplane to an owner and includes the purchase date [Pdate]. Each relationship instance in MAINTAIN relates an employee to a service record [SERVICE]. Each plane undergoes service many times; hence, it is related by [PLANE-SERVICE] to a number of service records. A service record includes as attributes the date of maintenance [Date], the number of hours spent on the work [Hours], and the type of work done [Workcode]. We use a weak entity type [SERVICE] to represent airplane service, because the airplane registration number is used to identify a service record. An owner is either a person or a corporation. Hence, we use a union category [OWNER] that is a subset of the union of corporation [CORPORATION] and person [PERSON] entity types. Both pilots [PILOT] and employees [EMPLOYEE] are subclasses of PERSON. Each pilot has specific attributes license number [Lic-Num] and restrictions [Restr]; each employee has specific attributes salary [Salary] and shift worked [Shift]. All person entities in the database have data kept on their social security number [Ssn], name [Name], address [Address], and telephone number [Phone]. For corporation entities, the data kept includes name [Name], address [Address], and telephone number [Phone]. The database also keeps track of the types of planes each pilot is authorized to fly [FLIES] and the types of planes each employee can do maintenance work.
List the courses (D-code and C-no), along with the names of the students who are currently taking them. List all the courses (D-code and C-no) that John (i.e., S-Name=''John'') got 'A' grade.
Use Cases Perform a requirements analysis for the Case Study
Is software measurement equivalent to software metrics? What makes them different?
Create a state transition diagram that describes typical student states and how they change based on specific actions and events.
Write a query that performs an inner join of the grade, student, and grade_type tables using ANSI SQL 99 syntax (JOIN ON).
Suppose that we replace the wait and signal operations of monitors with a single construct await(B), where B is a general Boolean expression. Write a monitor using this scheme to implement the readers--writers problem.
MCIS 630 Database Systems: - Write a recursive SQL query that outputs the names of all subparts of the part with part-id “P- 100”.
Design a scheme for determining exactly which one of the wine bottles was poisoned in just one month's time while expending O(logn) taste testers.
Write down the SQL code in order to carrying out the following requests. Display all the data in each of the four tables. Do not display the foreign key columns.
Explain what is the purpose of Database? The purpose of a database is to store information about certain types of objects. Give an example of two related TABLES.
Pick one of the different types of SQL statements (data definition language, data manipulation language, or data control language). Describe how that type of statement is use.
You have a file which contains credit card records. Each record contains field for the card number, expiration date, and name of card holder. Explain what primary problem you try to solve is.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd