Analyze the following scenarios and mention in which normal form it is withreason?
Q: Construct the relational model of the following scenario. System…
A: The following images shows the answer..
Q: ke a look at the table above and provide examples of insertion, deletion and update anomalies.…
A: Anamolies: INSERTION: A new course cannot be inserted if there is no student taking the course.…
Q: For the battleships database schema defined above in question 4, write the following as tuple-based…
A: Hey there, I am writing the required solution based on the above given question. Please do find the…
Q: Based on the given ERD, identify all the business rules and explain them. Also, identify all primary…
A: Answer : Business rules refer to types of constraints that are present among different…
Q: Schema: Part(PartNo, PartName, VehicleType, UnitPrice, SalesPrice) Service(ServiceNo, PartNo,…
A: CREATE OR replace FUNCTION getprofit ( p_part_number IN NUMBER) RETURN NUMBER IS l_part_name…
Q: 110. Goals for the design of the logical schema include a. avoiding data inconsistency b. being able…
A: Goals for the design of the logical schema include: a. avoiding data inconsistency b. being able to…
Q: Supposing we have the following database schema: Emp(SSN,Name, position, Dept) Dept(code,name,…
A: Answer:- select Dept, count(SSN) from from EMP group by Dept;
Q: Develop an eer diagram and write all enterprise rules that were used. Derive a logical base design…
A: Summary:In this question, we need to create a database for the visa management processing system.
Q: Which of the two choices below are the reasons why the relation below is not BCNF. in_dep (ID,…
A: Actually, BCNF is Boyce Codd normal form. It is the advance version of 3NF.
Q: Refer the schema and create the Subject table Refer the below schema diagram: College Management…
A: Given in the problem we have to create the subject table according to the given table schema. We…
Q: ORDER LINE PRODUCT STORE ORDER Hplaces contains is written in empoys EMPLOYEE DEPENDENT has Given…
A: Entity Relationship Diagram (ERD) is a graphical representation of entities and relationship among…
Q: Assignment 4: Question#1: Give any three examples of transaction where next operations are…
A: A transaction is a set of tasks to perform and complete a particular operation. To keep the…
Q: QUESTION 6 is when the data is rendered as inaccessible when it is no longer required. Availability…
A: The correct answer is
Q: Refer the schema and create the Subject table Refer the below schema diagram: College Management…
A: Based on the schema provided, we need to create subject table : where subject_id is primary key and…
Q: Make an ERD Daigram of inventory manegment system with the following entities : Product Category…
A:
Q: Discuss the concept of physical and logical back up with appropriate example. Assume that as a DBA…
A: PHYSICAL AND LOGICAL BACKUP: Physical backup: This is the backup which is done by copying the data…
Q: Which of the following best describes a relationship in which each instance of data in one entity…
A: One to One: An instance of data in one entity can be associated with at most one instance of other…
Q: simple draw state diagram that describes the system functionality dynamic management of resources…
A: State diagrams model a system from a single class perspective and events that can affect class…
Q: The following data structure and constraints exist for a magazine publishing company: a. The…
A: ANS: - The CUSTOMER table must be partitioned horizontally by state.
Q: Regional Labs is a company that conducts research and development work on a contract basis for other…
A: There is no question mentioned. So here is what I can answer:
Q: Suppose you have the ERD shown in the figure.How would you convert this model into an ERM that…
A: Convert M:N into 1:M relationship Given model is in M:N relationship. ERM - Entity Relationship…
Q: a. The following pair of concepts are related in some way and different in another. Explain how the…
A: a) Similarities: Table: It is a collection of rows and columns. Here, all the rows are…
Q: Consider the table (employee) below: Emp_qualification Dept_id BSc, A01 Emp_no Emp_name Dept_name…
A:
Q: You are a database developer for a Games company. The company develops games. The company needs to…
A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…
Q: . Which of the following is/are the Database server functions? i) Data management ii) Transaction…
A: (i)Data management is an administrative process which includes validation,protection,storing, and…
Q: 2.2 Which type of relationship is shown in each case below? Motivate your answer. Q.2.2.1 manages…
A: Here have to determine about type of relationship of given table.
Q: xplain the code below in a step-by-step manner. Also explain what the two join statements intend to…
A: emp = [(1,"Smith",-1,"2018","10","M",3000), \ (2,"Rose",1,"2010","20","M",4000), \…
Q: Refer the below schema diagram: College Management System(CMS) Department Student department_id…
A: Brief Introduction: We have to develop a SQL query to display the required fields according to given…
Q: Functional dependencies Patient_id --> p_name, phone,email,home_address…
A: Step 1:- Given:- Functional dependencies:- Patient_id --> p_name, phone,email,home_address…
Q: The following figure present BANK ER diagram. Map it into a full relational schema. Specify all…
A: Step 1: Mapping of regular Entity Types For each regular entity type E in the ER diagram, create a…
Q: How do we know the following relation with the following dependencies is BCNF? course (…
A: Explanation: BCNF stands for Boyce-Coded Normal form. A relation is in BCNF if and only if X is…
Q: 40. The value of the data item prior to the write is called as _________ a. Transaction identifier…
A: Given that, 40. The value of the data item prior to the write is called as _________a. Transaction…
Q: A Customer wants to order some products from any super shop through online. Super shop authority…
A: The, given information is A Customer wants to order some products from any super shop through…
Q: Which data flow diagram (DFD) symbol is usually portrayed with a square? data flow…
A: Here in this question we have asked that which of the DFD symbol is portrayed by square..
Q: Refer the below schema and create the table mark. Refer the below schema diagram: College Management…
A: Here we have to create the table mark from the database schema given. We use CREATE command for…
Q: description. password Admin id id password Admin login Company login User name has password Android…
A: Below is the relational schema for given ER diagram:
Q: Convert each of the following schemas to 3NF, showing all intermediate stages, that is, 1NF and 2NF.…
A: Normalization is used to reduce the data redundancy and anomalies in the schema. Basic rules for…
Q: . In database schema, the database snapshot is also called a. current set of entity b. current set…
A: A database schema represents the logical configuration of all or part of a relational database. It…
Q: Which of the following statements are correct about EER model for this requirement? Book,…
A: 1. Generalization :It works on the principle of bottom up approach. In Generalization lower level…
Q: maximum response time for predefined queries and a ten-minute maximum response time for ad hoc…
A: Find out the functional and non-functional requirements: 1) have a two-second maximum response…
Q: hat type of database is typical for this purpose: Fast delivering of data objects of different data…
A: A Relational database may be a kind of database that stores and provides access to data points that…
Q: Consider the File Structure for the XYZ Company Project Management data given below. Then,…
A: Given: A File Structure for the XYZ Company Project Management data consisting of several fields.…
Q: Customer details Customer Customer details Account details Open Account Customer Service Assistant…
A: Pick any of the above systems and designs the Entity-Relationship Diagram(ERD) for that system based…
Q: Describe how join types can be used to develop a schema statement. Include the roles a cross join…
A: When considering the database operations, the joins are accomplished in the sources of the…
Q: Application: Read, understand and analyze the following case and provide answers to the below…
A: Use case diagrams are the ones which are used in describing the high level function and system…
Analyze the following scenarios and mention in which normal form it is withreason?
- a) Employes
Emp_Id |
Emp_Name |
Emp_City |
Branch Id |
Branch Location |
b)Items
Item_Id |
Item_Name |
Description |
Expiry Date |
c)Order
OrderNo |
ProductID |
Product Description |
d)Teacher
TID |
CNIC |
Address |
T_Name |
e)Department
DeptNo |
Location |
DeptName |
Manager Name |
Manager ID |
Step by step
Solved in 2 steps with 1 images
- For the given design, Which of the following is NOT true about the design? Select one: a. It supports modular design. b. The AuthenticateUser sequence diagram can be reused only after a doB message call. c. The AuthenticateUser sequence diagram can be reused only when the authenticate() message is invoked on a B object. d. The DoFoo sequence diagram can be reused in any context where a B object and a C object are involved. e. The doB message must be called after the doA message.Create an Activity model (Application layer) for the following “Borrow Books” Use Case from the Use-Case Description: Normal Flow of Events: 1. The Borrower brings books to the Librarian at the checkout desk. 2. The Borrower provides Librarian their ID card. 3. The Librarian checks the validity of the ID Card. If the Borrower is a Student Borrower, Validate ID Card against Registrar’s DB. If the Borrower is a Faculty/Staff Borrower, Validate ID Card against Personnel DB. If the Borrower is a Guest Borrower, Validate ID Card against Library’s Guest DB. If the ID Card is invalid, the book request is rejected. 4. The Librarian checks whether the Borrower has any overdue books and/or fines. If the Borrower either has overdue books, fines, or both, the book request is rejected. 5. The Borrower checks out the books.Create a Sequence model (Application layer) for the following “Borrow Books” Use case for Students with a Valid ID and No Overdue Books or Fines from the Use-Case Description: Normal Flow of Events: 1. The Borrower brings books to the Librarian at the checkout desk. 2. The Borrower provides Librarian their ID card. 3. The Librarian checks the validity of the ID Card. If the Borrower is a Student Borrower, Validate ID Card against Registrar’s DB. If the Borrower is a Faculty/Staff Borrower, Validate ID Card against Personnel DB. If the Borrower is a Guest Borrower, Validate ID Card against Library’s Guest DB. 4. The Librarian checks whether the Borrower has any overdue books and/or fines. 5. The Borrower checks out the books. Alternate/Exceptional Flows: 4a. The ID Card is invalid, the book request is rejected. 5a. The Borrower either has overdue books, fines, or both, the book request is rejected.
- Question: An object of class ReportEmergencyForm is created when object of ReportEmergencyControl sends the «create» message and is destroyed once the EmergencyReportForm has been submitted. In general, the second column of a sequence diagram represents the boundary object with which the actor interacts to initiate the use case (e.g., ReportEmergencyButton). The third column is a control object that manages the rest of the use case (e.g., ReportEmergency– Control). From then on, the control object creates other boundary objects and may interact with other control objects as well (e.g., ManageEmergencyControl). ? Create Collaboration diagram for the above described scenario(1 point) (select all that apply) Which environment is the parent of e as created below: e = new.env()A) globalenv()B) baseenv()C) emptyenv()D) environment()E) parent.env(emptyenv())Which one of a,b,c,d correct? The comment must be enclosed within a) /* …*/ b) /** …**/ c) /**..*/ begins with free text describing use of the entity in question. If the entity is a method, then the comment should also include a) a $param tag followed by a name of the parameter b) a @param tag c) a full description for each parameter, followed by a description of its use. If the method is not void, there should also be a a) $return val b) full description c) return value specifying the value returned by the method
- In this question, don't change code just following the instructions #!/usr/bin/env python """ An example python script to illustrate how a projection might be simulated, and lead to an example GROUP BY ( using dictionaries to group and aggregate ) """ import sys, os, time import csv from datetime import datetime from optparse import OptionParser class SQLProjectionExample: def __init__(self): """ The SQLProjectionExample constructor includes the logic for arg handling. In effect, we assume this class will be run on the command line with a main. """ self._opt_defaults = {} self._opt_parser = OptionParser() self._opt_parser.add_option( '--table', '-t', action = 'store', dest = 'table', help = 'Table' ) self._opt_parser.add_option( '--columns', '-c', action = 'append', dest = 'columns', metavar = 'col', help = 'column' ) self._opt_defaults['test'] = False (self._opts, self._args) = self._opt_parser.parse_args() def show(self): """ Simple standard utility function for illustrating argument…From your project’s component, suggest an example of each of the following: Functional requirementNonfunctional requirementAggregation relationshipGeneralization relationshipDevelop the Java program for the continuous evaluation (CE) mark-sheet portal as mentioned below: Weight of the class test is 30% , sessional is 40% and innovative assignment is 30 %. So total is 100. Minimum 40% of marks is mandatory to clear the CE component Data/attributes for portal: RollNo,CourseCode,ClassTestMark, SessionalMark, InnovativeAssignmentMark, Semester i.e. 19BCE999, 2CS302, 20, 10, 25, 3 The portal has following functionalities: Add mark functionality for each component Delete and update mark functionality for each component Display mark functionality for each component RollNo-wise Scan semester from user and generate report for course-wise component-wise failure student list. You have to use multi-dimesional array, inheritance and exception handing concepts compulsory. You may use other concepts of Object Oriented Programming if require
- Open your text editor and create a new document named model.php model.php will connect to a database potentially return PDO statement objects to the controller for processing. This question is complete and requires use of initMessagesfunction initMessages($tim) This method will take a single parameter of unix time using the method “time()”. It will conditionally select fromthe table “messages” the minimum id and rename it to “min_id”. The condition is that the field time is greater thanthe parameter for time. The return is the PDOStatement object with the row data from a query.1.Write all functional requirements which are required to implement “Search a cab” use case. 2.Explore any two high priority quality attributes which are very important for “Get a cab” application with brief rationale. 3. Write all possible testable non-functional requirements for above explored quality attributes. 4.Draw a use case diagram for “Get a Cab” application ‘Get a Cab’ is a Smartphone application. It will search cabs for the passenger, provide them with security by reminding them about their luggage and it will also allow the user to inform the police with the help of a one-click button. This application facilitates the guardians to trace the location of their loved ones. It also lets passengers locate a driver at any instance to overcome all time related issues. If the passenger wants to avail the services of the same driver in future, he/she can add the driver to the favorite list, stored in the application. 5.Write a detail use case for “Search a Cab” function. For…Which of the following is NOT true about the diagram? Select one: a. If the "description" attribute is separated as a class, "price" and "itemID" should be defined as attributes of the description class. b.It is a design class diagram. c.It captures real world concepts. d.According to the design, there will be no record of items left in the system after all item instances are sold out. e.It can be improved by taking out the "description" attribute and define it as a separate class.