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!
Cyber Transit Ltd keeps up-to-date information on the processing and current position of each dispatched item. Dispatched items are the main concern of the Cyber Transit product tracking information system. Dispatched items can be characterized by item number (unique), weight, size, destination, and final date of delivery. Dispatched items are received into the Cyber Transit system at a single retail center. Retail centers are characterized by their type, unique ID and address. Dispatched items make their way to their destination via one or more Cyber Transit transportation medium (i.e. flights, truck deliveries). These transportation medium are characterized by a unique schedule number, a type (e.g. flight, truck) and a delivery route.
Create an Entity Relationship diagram that captures this information about Cyber Transit Ltd.
Convert the ER diagram in figure above into its corresponding relational schema diagram.
What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and
Define Join and Outer Join and differentiate between them. Ans: Join - It generates all the combinations of tuples from two relations which satisfy a join condition. Oute
Indexed (Indexed Sequential) File Organisation It organises the file like a big dictionary, i.e., records are kept in order of the key but an index is stored which also allows
System level permissions : With the use of data dictionary you can view them. Let us take the table name as user_sys_privs (used in oracle). DESCRIBE USER_SYS_PRI
Scenario 1: Power goes out after the first instruction. What happens?
Question: A DBMS built for Online Transaction Processing (OLTP) is generally regarded as unsuitable for data warehousing. Each system is designed with a different set of requir
Entity types that do not have any key attribute, and therefore cannot be identified independently, are known as weak entity types. A weak entity can be recognized uniquely only by
What is meant by heuristic optimisation? Discuss the main heuristics that are applied during query optimisation. Ans: In heuristic optimization, heuristics are employed to r
Insertion Anomaly: Inability to show certain information-The primary key of the over relation be (enrolment number, Cno). Any new tuple to be inserted in the relation should have
Aggregate functions Some of these functions are min, count, max, and avg. These functions help in getting consolidated information from a set of tuples. Example:
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd