Reference no: EM132111172
Question :
PSSC is a brokerage firm that buys and sells stocks for its clients. Thus, the main actors are broker and clients. PSSC has offices in different cities and each broker works in only one of these offices.
A broker can also be an office manager (For the office he/she works in).Clients own accounts, and any account can have more than one owner like joint account. Each account is also managed by at most one broker.
A client can have several accounts and a broker can manage several accounts, but a client cannot have more than one account in one office.
Given these conditions, design an ER diagram for this application using CHEN's notation, no other notation is acceptable and will not be graded. Write any unspecified requirements and any assumptions that you need to make the specification complete.
In your ER diagram;
a. Identify each entity type and relationship type.
b. Identify attributes and key attributes for each entity type and/or relationship type.
c. Identify all of the structural constraints. ER diagram required using CHEN'S notation with list of assumptions made.
|
Write a sql query that will give the employee number
: Write a SQL query that will give the employee number, employee name and hired date from the EMP table.
|
|
Create a sql query that will use the count function
: Create a SQL query that will use the count function to return the number of employees in each department in the emp table.
|
|
A program to simulate signals of a pedestrian traffic light
: Specifically, the car lantern will light up for 10 seconds, then turn off and turn on the pedestrian traffic light for 7 seconds.
|
|
Create a sql query in the sql command window showing
: Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate from the emp table.
|
|
Identify all of the structural constraints
: Identify all of the structural constraints. ER diagram required using CHEN'S notation with list of assumptions made.
|
|
Design a program that continuously accepts
: Design a program that continuously accepts an author's name, number of books Written, and target reader age until a sentinel value is entered.
|
|
Write a for loop that checks whether two string arrays
: Rewrite the following for loop using the "for each" construct to add the length of each String element from the data array to the totalLength.
|
|
Create a cell phone app that will allow the user to view
: A timeline, with check off dates (dates for different parts of the project to be completed and approved by your boss), and a completion date.
|
|
Prompt the user to type in a string of characters
: Return the position of the string and print the message "found" and its position in the text onto the screen either in a Message Box or to the Console.
|