Kindly click here to proceed with this order or request a similar one…..
Create the ERD using UML notation to show the relationships between DENTIST, PATIENT and SURGERY. Also show the multiplicity in the relationships and attributes. The patient must be examined by more than one dentist and a dentist can examine at least one patient; Dentist number, dentist name, office number, cellphone number and email address must be captured on the system; A dentist can examine more than the minimum of three patients per day; The following patient details need to be captured on the system: patient number, patient name, street address, email address; Each surgery is assigned an examination at the time as instructed by dental clinic policy.
Question 3 Complete the statements below by filling in the missing words. The words are provided in the table. Write down the question number and next to it the correct answer. For example, 3.1 Entity.
A table is perceived as a (Q.3.1) structure composed of tables, rows, and relationships (1). Each table column represents an (Q.3.2), and each column has a distinct name (1). Each cell or column/row intersection in a relation should contain (Q.3.3) atomic value (1). Each column has a specific range of values known as the (Q.3.4) (1). Each (Q.3.5) does not need to have an attribute or a combination of attributes that uniquely identifies each row (1). A foreign is an attribute in one table whose values must either match the primary key in another table or be (Q.3.6) (1). A candidate key is a minimal (Q.3.7) that does not contain a subset of attributes that is itself a superkey (1). A (Q.3.8) is a candidate key selected to uniquely identify all other attribute values in any given row and cannot contain null entries (1). A secondary key is an attribute used strictly for (Q.3.9) purposes (1). A (Q.3.10) is an attribute that uniquely identifies each row in a table (1).
Kindly click here to proceed with this order or request a similar one…..
Leave a Reply