Task Description: Consider the following relations for a company: Department (Did: integer, Dname: string, location: string) Employee (Eid: integer, Ename: string, Erank: integer, salary: real, DepartmentID, integer) Project (Pid: integer, DepartmentID: integer, Pname: string, budget: real, start year: integer) The “DepartmentID” fields in both Employee and Project are foreign keys referencing the “Did” field of the Department table. Through Java application, use SQL to insert (random but meaningful) data records in the above tables: 1) Create two different departments (named: Marketing and Human Resources) 2) Create at least three employees per department (6 employees in total). A rank of an employee is an integer value between 1 and 3. 3) Create at least three different projects per department (6 projects in total). The start year is between 2018 and 2020.

Task Description: Consider the following relations for a company: Department (Did: integer, Dname: string, location: string) Employee (Eid: integer, Ename: string, Erank: integer, salary: real, DepartmentID, integer) Project (Pid: integer, DepartmentID: integer, Pname: string, budget: real, start year: integer) The “DepartmentID” fields in both Employee and Project are foreign keys referencing the “Did” field of the Department table. Through Java application, use SQL to insert (random but meaningful) data records in the above tables: 1) Create two different departments (named: Marketing and Human Resources) 2) Create at least three employees per department (6 employees in total). A rank of an employee is an integer value between 1 and 3. 3) Create at least three different projects per department (6 projects in total). The start year is between 2018 and 2020.

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter10: Classes And Objects

Section: Chapter Questions

Problem 3MQ1

See similar textbooks

Similar questions

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?
c++ language Create Class Student▪ Data Members: Name , ID and GPA.▪ Make the data members visibility to be private.▪ Use setter and getter method for each attribute.▪ In the main, set values for the student details using setter function, then retrieve the value using the getter function.▪ Print what you retrieve
Refer again to the UML Class Description for Student. Write the code for the class_text method using a dictionary structure to assign the appropriate text value for the class_code value.
In Visual Basic, a double data type would be comparable to what SQL data type.
in a shop ,there are 10 employee and 20 kinds of goods，goods id between 1-20 EMPLOYEE id first name last name gender 10001, 'Tom', 'Brown', 'F'10002, 'Elizabeth', 'Tremblay', 'F'10003, 'Gladys', 'Julie', 'F10004, 'John', 'Taylor', 'M10005, 'Amelia', 'Smith'10006, 'Logan', 'Katherine'10007, 'Leo', 'Brown'10007, 'Lem', 'Thompson'10009, 'Tom' 'Smith'10010, 'Emma', 'Campbell' ------------ and I want to add a name library in it ,like this how could i create a HTML file ,with will randomly create customers with these employee . there is a start button on the page . press "start "bottom ,and it will It will randomly match 10 items, customers, and goods, display goods id ,customername and gender ,employer name , id and gender . how to do such a page ?
Task Class Requirements The task object shall have a required unique task ID String that cannot be longer than 10 characters. The task ID shall not be null and shall not be updatable. The task object shall have a required name String field that cannot be longer than 20 characters. The name field shall not be null. The task object shall have a required description String field that cannot be longer than 50 characters. The description field shall not be null. Task Class with JUnit test case with it! Please do not copy and paste from others with TaskService. It's not helpful and does not relate to what I am doing. Thank you. Java language
FD's BookID -> Title BookID > Author Title BookID Title -> Author Author -> Title Author -> BookID IS THIS 1NF? Yes this is 1NF. BECAUSE THERE IS SINGLE VALUE ATTRIBUTES.
a) TEMPID (Corp-ID = "Amawig") (works) b) TEMPID, City (Employee ▷ (corpan = " Amouig" (works)) c) TEmpID, City (CorpID="Amoudig" A Salary > 100000) works Employee d) EmpIn (Employee works Corporation) e) TEMPID ((Employee Amonages) MngrID = employee 2. EmpID A employee-Zipcode · Employce 2. zipcode ^ Employee.City = Employee 2. City) (Pemployeez (Employee)))
Computer Sicence Objective: To create a JSON for Scheme details with objects Scenario: Government wants to create a database for schemes launched in respective country. Application sends the details of schemes in the form of JSON Help to create a JSON with the information provided. Name Datatype of value Scheme String MinistryDetails Object LaunchedYear Number Country String BudgetInCrores Number MinistryDetails- Object : Name Datatype of value Ministry String MinisterName String HeadOfMinister String NOTE: You can assume any data for the mentioned JSON structure, provided it is matching the specified datatype
The "SUPERVISES" Relationship is considered as: EMPLOYEE SUPERVISES O 1. Ternary Relationship O 2. Identifying Relationship O 3. Recursive Relationship O 4. Binary Relationship
Food delivery application: This system allows the customers to search and order the food etc. online. The administrator can also use the system for administrative purpose like add and delete dishes etc. Create your own case study (problem statement) for the above application and 1. Draw the use case diagram 2. Class diagram with at least 4 classes and explain all the relationships 3. Draw a DFD-0 for this application
Task Class Requirements The task object shall have a required unique task ID String that cannot be longer than 10 characters. The task ID shall not be null and shall not be updatable. The task object shall have a required name String field that cannot be longer than 20 characters. The name field shall not be null. The task object shall have a required description String field that cannot be longer than 50 characters. The description field shall not be null. Verify with Juint testing as well