ifference between declaring the data members as private vs public
Q: Is it possible to control the integrity of a field by selecting a certain data type?
A: Integrity Refers To? Data integrity means complete accuracy, completeness, and reliability of data.…
Q: List the property IDs of any pair of properties that have the same number of bedrooms. For example,…
A: In this question we have to write a SQL query for the given statement Let's query and hope this…
Q: Which statement is true from the following: only protected elements can be inherited…
A: Option C. only protected and public elements can be inherited
Q: BookID -> Author or-> Title or-> BookID
A: First Normal Form (1NF): If a relation contains a composite or multi-valued attribute, it violates…
Q: What is the main difference between UNION and UNION ALL?
A: Question. What is the main difference between UNION and UNION ALL? Answer. UNION and UNION ALL are…
Q: The attribute AGE is calculated from DATE OF BIRTH. The attribute AGE is: A Single valued. B…
A: Answer:-(C) - Derived is correct answer.
Q: Do composite attributes have the ability to be included in composite keys?
A: Introduction: More than one characteristic may be included in a composite key. Attribute names for…
Q: Complete the entries: 1. Set methods are commonly called v methods. 2. Set methods change v fields.…
A: As we know data of an object must be kept private. However, if any data member is declared private,…
Q: Question 7 In PDO Prepared Statement, which of the following method allows parameters to be given as…
A: Ans: In PDO Statement, the following method that allows parameters to be given as input by…
Q: Consider the following function: def rate(n): i = 0 total = 0 while i true) * 10 times (i.e. 10…
A: The given function is: def rate(n): i=0 total=0 while i<20: total…
Q: Primary keys and candidate keys may both be assigned to the same attribute.
A: In relational databases, keys are attributes or combinations of features that can be used to…
Q: (vin, make, model, year) - car vehicle ID #, manufacturer, mod mple: (17234, Toyota, Prius, 2008) or…
A: I have written the query below:
Q: The following normal form preserves all functional dependencies A. 4NF B. 3NF…
A: EXPLANATION: Other than a candidate key, the fourth normal form (4NF) is a level of database…
Q: Customer ={idC(PK), surname} Contract ={idC(PK), customer, consultant, insurance_type, date}…
A: SQL statements editable using MS SQL Server CREATE TABLE Customer(idC char(5) PRIMARY KEY, surname…
Q: Description The Employee table holds all employees including their managers. Every employee has an…
A: SQL query : -
Q: What is the purpose of field values being coded
A: This question tells about the purpose of field values being coded :
Q: STORY BOOK # Id Name * Published date o Publisher Type Find the error in the given ERD written by…
A: ERD stands for Entity-Relationship Diagram. It is a visual representation of the relationships…
Q: Is it feasible to control the integrity of a field by picking a certain data type as the value for…
A: Data integrity refers to the accuracy, consistency, and reliability of data throughout its…
Q: Use C# to create Order class as follows: a. Data members: oid, orderDate, promised Date, shipDate,…
A: The objective of the question is to create a class in C# that represents an Order with specific data…
Q: A potential key exists for a composite primary key's property. How do you feel about this news?
A: In the context of relational databases, primary keys are critical for uniquely identifying a record…
Q: Design Database for the following scenario and Write SQL queries. Create an ERD for the following…
A: Create an ERD for the following scenario.Suppose there is a grocery store near your house. Answer:…
Q: Use C# to create Order class as follows: a. Data members: oid, orderDate, promised Date, shipDate,…
A: Create a class Order with the private data membersCreate a constructor order that initialises the…
Q: Q1 ): You are about to design a university database to keep information about departments,…
A: Department - Department Code, Name, Chairperson Initials (FK) references TenuredProfessor (Initials)…
Q: In java create an application to manage your data bas information the database is already created in…
A: To create a Java application to manage your MySQL database, you can use JDBC (Java Database…
Q: Member m = new BoardMember(); Is this statement legal or illegal and widening or narrowing…
A: Given statement: Member m = new BoardMember(); To find: Is this statement legal or illegal…
Q: Temporary Employment Corporation (TEC) places temporary workers in companies during peak periods.…
A: Data dictionary that defines the database: i. candidate{ #c_id, c_name, c_address, c_email, c_ph}…
Q: calculate_new_balance Given a starting balance (a number), and a list of transaction tuples,…
A: Given: Given a starting balance (a number), and a list of transaction tuples, calculate the final…
Q: Which of the following is false regarding a const-qualified member function? O the function cannot…
A: const qualified member functions are the member functions that doesn't changes any members values
Q: State the difference between projecting and joining.
A: SQL Projection is a process of displaying the data from a relation or a table It is used for viewing…
Q: One of the components of a composite primary key might be a candidate key. What would you do if you…
A: Composite primary key is a combination of multiple columns and these columns are used to identify…
Explain the difference between declaring the data members as private vs public
Step by step
Solved in 3 steps with 1 images
- Customer ={idC(PK), surname} Contract ={idC(PK), customer, consultant, insurance_type, date} Consultant means: id of some Staff member Staff={idPerson(PK), surname,dob, boss, email} Dob means: date of birth, boss: is id of another Staff member supervisor Insurance_Type={idT(pk) , Tname , price , length } Length = number of months it is valid (from the date when it was bought ) Find consultants born after some contract was already signed?Q2: Design Database for the following scenario and Write SQL queries. Create an ERD for the following scenario. Suppose there is a grocery store near your house. Following can be considered for ERD: A grocery store may have more than one employee. A grocery store has exactly one manager. The manager has one or more sales men working under him. Grocery store has more than one portion for the products. • Each product has a barcode, name, expired date. Many customers can busy many products, but each product is bought by only one customer. Each customer will get an invoice for his /her purchase. The bill invoice has an id.Q1 ): You are about to design a university database to keep information about departments, professors, and course offerings. Here is what you have been told about this application. Departments are identified by a code (e.g. CSE) and have a name (e.g., "Computer Science and Engineering"). Professors are identified by their initials (like "MNK1"), they have a name, and they are affiliated with at least one department. Professors are either tenured ("tenured" means permanent) or junior (they have to be in one of these categories and they cannot be in both). For tenured professors we want to know the year they earned tenure (year when they became permanent) and for junior professors we want to know the date they were hired. Finally, a department has exactly one chairperson who must be a tenured professor in any department (i.e., there is no requirement that the chairperson is affiliated with the department s/he chairs). A department (e.g., CSE) lists courses to be offered to students for…
- Is it feasible to control the integrity of a field by picking a certain data type as the value for that field?Which statement is true from the following: only protected elements can be inherited only private elements can be inherited only protected and public elements can be inherited all elements can be inheritedThe Wrecks 'R Us Auto Repair Shoppe has a database to keep track of cars, repair orders, and repair technicians. The database has the following tables: Car(vin, make, model, year) - car vehicle ID #, manufacturer, model, and year; for example: (17234, Toyota, Prius, 2008) or (38953, Chevy, Nova, 1968). --. Technician(techid, name, yearhired) -- technician ID number, name, and year hired. CanFix(techid, make, model) -- table listing the car makes and models that a technician can fix. Order(num, vin, techid, year, month, day) -- repair order #, car ID, technician ID, and date. Write a SQL query that produces a list of the names of all technicians who repaired a Ford car before the year 2002. The list should be sorted in a descending order by technician name and should not contain duplicates.
- In java create an application to manage your data base information the database is already created in mysql tables, the tables are fill, So the user can use your database application user friendly Retrieve all data: Given a table name, retrieve all data from the table and present it to the user. Average: Given a table name and a column name, return the average of the column. Here the assumption is that the column type will be numeric (e.g., cost column). Insert: Given a table name, your program should show the column names of that table and ask the users to input new data to the table. In case of errors, your program should directly show the MySQL errors to the users. Assumption 1: Users will enter data according to the database constraints. Assumption 2: Users will input one record at a time. Delete: Given a table name, your program should show the column names of that table and ask the users to input data that they want to delete. Assumption 1: Users will enter data according to the…Is it possible to control the integrity of a field by selecting a certain data type?Member m = new BoardMember(); Is this statement legal or illegal and widening or narrowing conversion.